Sum amount if = 2 value's

L

loscherland

I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month

A B C
Type Amount Month


I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month

Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????

Any idea's
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding some list items 1
Nested IF / SUMIF statements 2
using fiscal year calculations in a formula 1
Calculating total amount in a Pivot Table 1
Sum up 2 or more columns under same SUMIF criteria 2
I need help to make a not-so-easy AVERAGE formula! 4
Sum Multiple Tabs of Data 2
Creating Pivot Table with Macro using Multiple Sheets 0

Top