Trickey SumProduct with Multiple Conditions

B

Benjamin

=SUMPRODUCT(--(A1:A24="Ted"),--(B1:B24="May"),--(C1:C24))
column a <Person>, column b <Month>, Column C <Cost>

I need to total all of Ted's Costs for May.
But Now I need to do it for the quarter.
So for say January, Feburary, March and April, four month blocks.
How would I tweak Sumproduct to do that ...
All cost for those four months.
 
T

T. Valko

List the month names for the quarter in a range of cells:

E1 = Jan
E2 = Feb
E3 = Mar
E4 = Apr

F1 = Ted

Then:

=SUMPRODUCT(--(A1:A24=F1),--(ISNUMBER(MATCH(B1:B24,E1:E4,0))),C1:C24)
 

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

SumProduct - With Or Function 2
Multiples conditions in an array 3
sumproduct - multiple conditions 7
sumproduct with multiple variables 8
sumproduct with 4 conditions 1
Sumproduct with mulitple criteria containing equals and or's 6
Sumproduct with three arrays 2
Lookup Postage Price [min & max weight] 1

Top