I have a list of data, which goes something like this

Month Type Amount
Jan A 10
Jan A 15
Feb B 10
Jan B 5
March A 20

etc

Now, I have a second sheet, which I want to go something like this..

Jan

Type A TOTAL
Type B TOTAL

Feb

Type A TOTAL
Type B TOTAL

Mar

Type A TOTAL
Type B TOTAL

In order to do this I need to have a formula which says

"SUMIF (Month=Jan and Type=A)"

Is there anyway to do this?


--
grey
------------------------------------------------------------------------
grey's Profile: http://www.excelforum.com/member.php...o&userid=17951
View this thread: http://www.excelforum.com/showthread...hreadid=391795