Sum amount if = 2 value's
 

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?


--
loscherland
------------------------------------------------------------------------
loscherland's Profile: http://www.excelforum.com/member.php...fo&userid=6709
View this thread: http://www.excelforum.com/showthread...hreadid=384297

=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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=384297