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