Summing lookups?

[Xabu]

Is this doable?

I have a table with vertical values jan,feb,mar,apr,may,jun.

I want to dynamicaly SUM values from-to ie:

Rangee of the table with data is : R42C1:R56C11

R1C1:jan
R1C2:may

R1C3:=SUM((VLOOKUP(R1C1;R42C1:R56C11;2;FALSE)VLOOKUP(R1C2;R42C1:R56C11;2;FALSE))

Basicaly, I want to be able to change the months in R1C1 and R1C2 an
that sum range changes dynamicaly (ie. feb-august etc.)

If that's not doable, is there any other way?

Thank

 

[...Patrick]

with a pivot table, it is easy !!!


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel

 

[Frank Kabel]

Hi
are your month names stored as 'Text' values or as real date values
(just formated to show only the months)

 

[Xabu]

Thanks for the prompt reply,

I need a solution that will do that kind of calculation for long-term -
something that will stay unchanged. I just want to specify the range
dynamicaly.

Pivot tables afaik, refresh when data stays the same and values change,
othervise I'll have to modify the settings every tima I want different
results and that is not what I want.

maybe I just lack knowledge in pivot tables and it's doable as you say
... could you please describe the way to me?

Thanks

 

[Xabu]

*Hi
are your month names stored as 'Text' values or as real date values
(just formated to show only the months)

--
Regards
Frank Kabel
Frankfurt, Germany

*

they are text value

 

[Frank Kabel]

Hi
then it's getting a little bit more difficult. Would be easier if they
were dates. But try:
=SUM(OFFSET(R42C2,MATCH(R1C1;R42C1:R56C1,0)-1,0,MATCH(R1C2;R42C1:R56C1,
0)-MATCH(R1C1;R42C1:R56C1,0)+1))

 

[Xabu]

Thank you very much for your help.

It is all working now, just in time to finish my report.

Best regards,

Mihae