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