Summing categories for each month

[wnstar21]

Please see the attached file I am working with.

I need to find out how much we paid in each category in each month. I would like to put formulas in the table starting near cell D3.

What formula can I use to sum the total for each category in column C (Tires, Parts, N2, etc.) under each month in column A?

Thanks!

[DonkeyOte]

To avoid need for expensive SUMPRODUCT (and assuming Pivot Tables not viable) then I would advise:

Please Login or Register  to view this content.

[zbor]

Try this in E3:

=SUMPRODUCT(--($A$13:$A$1000=$D3);--($C$13:$C$1000=E$2);$B$13:$B$1000)

and extend over whole table.

(replace ; with , if needed)

but better take DQ advice.

[vorabha]

if you can try thru Pivot, more simpler way

see attached

[wnstar21]

Thanks so much Donkey!