Multiple Sum Formula With Multiple Constraints

[sandz23]

Hi all, just wondering if anyone has a good idea to solve this problem. I have listed data below for purposes of the formula:

How do I get the data above, into a spreadsheet like the one below? I have tried If/Than Statements with no luck. I need to total the amount of invoices during a specific month for a specific customer.

[DonkeyOte]

Given use of XL2007, see SUMIFS function in XL Help.

If you have Jan, Feb in your headers you can obtain the month number either by conducting a COLUMNS($JanColumn:currentcolumn) or by using MONTH(1&headercell) ... either way the numeric result (1-12) can be compared to Invoice Month Column.

If you need more specific assistance I would suggest posting a sample workbook such that ranges are clearly identified etc...

[sandz23]

I just attached the excel workbook if that is any help.

[DonkeyOte]

Assuming you intend to keep the 1,2,3 etc in row 1

G5: =SUMIFS($C$5:$C$20,$A$5:$A$20,$F5,$B$5:$B$20,G$1)
applied across matrix

[sandz23]

Wow that works great! Thanks!