Ask Your Question

Revision history [back]

click to hide/show revision 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 .

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 .