Thread
:
Excel: Sumif function with two sets of criteria? Can it be done?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett