How to put TEXT as a parameter ?

[sporitus]

Hello experts,

A have a formula: =SUMIF('2007'!$Q:$Q,$E$3,Jan_2007)

Where Jan_2007 is a name of column. The formula works well!

I want the name Jan_2007 been extracted from B2. But if B2 = "Jan_2007" and I put it in the formula like like: =SUMIF('2007'!$Q:$Q,$E$3,B2) it doesn`t work.

Please advice, how to make the text from B2 been identified as a parametr for my formula ?

thanks

 

[VoG]

Try

=SUMIF('2007'!$Q:$Q,$E$3,INDIRECT(B2))

 

[sporitus]

VoG;

as usially, it works !!

Thaks a lot