HEEEEELLLLPPPP!

[coolVariable]

I have an excel sheet with different worksheets.
One lists all the single items with month, amount, and category.
The other is a yearly summary sheet where it lists the sum of the amounts for whole categories in a column for each month.

How can I automate the yearly summary so each cell automatically searches for items within a certain month where category equals some text?

 

[BlueWeasel]

Have you tried using AutoFilter?

 

[coolVariable]

How do I do that?


I tried these two:
=SUMIF('Expense Registery 2004'!B:B,7,'Expense Registery 2004'!G:G)

=SUMIF('Expense Registery 2004'!R:R, "Administrative", 'Expense Registery 2004'!G:G)


Basically I just need to include both in one formula:

'Expense Registery 2004'!B:B = 7
and
'Expense Registery 2004'!R:R = "Administrative"

How do I do that?

 

[coolVariable]

Why is this not working?

=SUM(IF(('Expense Registery 2004'!R:R="Administrative")*('Expense Registery 2004'!B:B=7), 'Expense Registery 2004'!G:G,0))

 

[coolVariable]

Or this?


=SUM(IF(('Expense Registery 2004'!R:R="Administrative"), SUMIF('Expense Registery 2004'!B:B, 7,'Expense Registery 2004'!G:G),0))