Sum amount if = 2 value's

[loscherland]

I have a spreadsheet of payment types for which I want to sum the total amount per type per month

A B C
Type Amount Month


I'm able to get the total amount per type by using =SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for each type each month

Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????

Any idea's?

[duane]

=sumproduct((a1:a1000="type")*(c1:c1000="month")*(b1:b1000))

where type is the type you want, and month is the month you want

see also

http://www.xldynamic.com/source/xld.SUMPRODUCT.html