Excel: Sumif function with two sets of criteria? Can it be done?
 

I have a spread sheet that has different organizations in column A, Dates in
Column B and payments received in C. I would like to do a calculation that
will add all of organizations received payments with a calendar month. I
know I can do a sumif function by date and a sumif by organization name. I
need to know if there is a way to do both. Thanks

Excel: Sumif function with two sets of criteria? Can it be done?
 

=sumproduct((a2:a22="orgA")*(month(b2:b22)=1)*c2:c 22)
or
=sumproduct(--(a2:a22="orgA"),--(month(b2:b22)=1),c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steelfan" wrote in message
...
I have a spread sheet that has different organizations in column A, Dates
in
Column B and payments received in C. I would like to do a calculation
that
will add all of organizations received payments with a calendar month. I
know I can do a sumif function by date and a sumif by organization name.
I
need to know if there is a way to do both. Thanks

Excel: Sumif function with two sets of criteria? Can it be done?
 

Hi,

Here's one way

=SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*(B1:B100<=D 3)*(C1:C100))

Where
D1= organisation name
D2= date of 1st day of the month to sum
D3 =date of last day of month to sum


Mike


"Steelfan" wrote:

I have a spread sheet that has different organizations in column A, Dates in
Column B and payments received in C. I would like to do a calculation that
will add all of organizations received payments with a calendar month. I
know I can do a sumif function by date and a sumif by organization name. I
need to know if there is a way to do both. Thanks