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?
Bookmarks