vlookup sum()?

[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!

 

[new_121]

I found it - you basically need to add vlookupM01 +VlookupM02 etc

 

[Sebation.G]

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

 

[Roger Govier]

Hi Claudia

Provided you enter your XXXX as a Text value, e.g. '2007
then
=SUMPRODUCT((LEFT(B$1:N$1,4)=A2)*(RIGHT(B$1:N$1,2)>="01")*
(RIGHT(B$1:N$1,2)<="03")*$B2:$N2)

 

[new_121]

Thank you everyone!

Hi Claudia

Provided you enter your XXXX as a Text value, e.g. '2007
then
=SUMPRODUCT((LEFT(B$1:N$1,4)=A2)*(RIGHT(B$1:N$1,2)>="01")*
(RIGHT(B$1:N$1,2)<="03")*$B2:$N2)