First time here? Check out the FAQ!

1 | initial version |

There are a few ways to solve this .

Let's start with making sense with your data .

First put your data in 3 columns .

The first column will be NAME (e.g. books,food.parking) .

The second column will be AMOUNT (e.g. 10,19.9,102) .

And the last column will be CRITERIA (e.g. cash,CreditCard,SexualFavors) .

Now , you use the function SUMIF that sums up all the numbers in the AMOUNT , if they match your CRITERIA .

Of course you can sumif in a few cells , where each cell sums according to a different criteria .

If you really need to spread your data in many columns , or , if you must depend on cell colours ...

Well , there are other ways to solve this .

2 | No.2 Revision |

There are a few ways to solve this .

Let's start with making sense with your data .

First put your data in 3 columns .

The first column will be NAME (e.g. books,food.parking) .

The second column will be AMOUNT (e.g. 10,19.9,102) .

And the last column will be CRITERIA (e.g. ~~cash,CreditCard,SexualFavors) ~~cash,CreditCard,SexualFavours) .

Now , you use the function SUMIF that sums up all the numbers in the AMOUNT , if they match your CRITERIA .

Of course you can sumif in a few cells , where each cell sums according to a different criteria .

If you really need to spread your data in many columns , or , if you must depend on cell colours ...

Well , there are other ways to solve this .

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.