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

Thanks,
Oscar.

=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)

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

Thanks,
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:

=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)

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

Thanks,
Oscar.

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)

"Oscar" wrote in message
...
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:

=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)

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

Thanks,
Oscar.