Display breakdown of items based on category

[hop-frog]

Hello,

I am creating a simple spreadsheet in Calc for maintaining a balance on multiple accounts, set up just like a checkbook, but with the addition of a breakdown of the information displayed on the second page (Sheet2) for the purpose of maintaining a budget.

A very simplified version of the balance sheet's column headings on Sheet1 follows:

Date | Payee | Category | Amount

Rows represent each transaction.

Now, lets say I have recorded the following transactions:

06/01/2006 | Wal-Mart | Groceries | $16.09
06/02/2006 | Olde Towne Bakery | Groceries | $2.15
06/03/2006 | Wal-Mart | Entertainment | $17.81

All of the above, I know how to accomplish. The resulting breakdown which would appear in Sheet2, however, I am not sure how to make, nor do I know if it is possible in Calc:

Amount spent on Groceries: $18.24
Amount spent on Entertainment: $17.81

Amount spent at Wal-Mart: $33.90
Amount spent at Olde Towne Bakery: $2.15

Somehow, it has to go through and search for all transactions categorized under Groceries and then display the sum total of all of just these transactions.

[noranthon]

The SUMPRODUCT function will do what you want.
_________________
search forum by month

[David]

[hop-frog]

Thanks!

[Nalo]

Hello,

I'm working on a similar spreadsheed and I have another similar question:

How can I get the amount spent on Groceries at Wal-Mart? Or how can I get the amount spent on Entertainment at Wal-Mart?

The problem is how to specify two conditions (over two columns) in =SUMIF( $C$1:$C$8;"Groceries";$D$1:$D$8 ) .

Thanks
_________________
----------------
Nalo

[Nalo]

Hello,

I have just found the solution!

=SUMPRODUCT( $C$1:$C$8="Groceries";$B$1:$B$8="Wal-Mart";$D$1:$D$8 )

Sorry for beg you with the question and the answer, but I think this will help somebody.

Regards,
_________________
----------------
Nalo

[Villeroy]