try:
=SUMPRODCUT((A:A="xxxx")*B:D)


--
Regards,

Sebation.G
"Claudia" ...
Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!