SumIf two axes

O

Oscar

How can I sum cells in range B2:F10 based on two criteria:
* A2:A10 = "XXX"
* B1:F1 = "YYY"

Thanks,
Oscar.
 
B

Bob Phillips

=INDEX(B2:F10,MATCH("XXX",A2:A10,0),MATCH("YYY",B1:F1,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
O

Oscar

Thanks, but you solution only finds value of one cell in range B2:F10. "XXX"
can be found in more thant one cell in range A2:A10 and "YYY", which can be
found in more than one cell in range B1:F1. I want to sum up values of all
cells in range B2:F10 that meet specified criteria.

Oscar

"Bob Phillips" je napisal:
 
B

Bob Phillips

I wondered if that might be the case, but thought, no, can't be <G>

=SUMPRODUCT((A2:A10="XXX")*(B1:F1="YYY")*(B2:F10))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top