Sumif
 

Hi

Is it possible to use a value from a pull down in a SUMIF statement?

=SUMIF(Forecast!B2:B218,Main!K11,Forecast!F2:F218)

I would like Forecast to be replaced by M6 on the "Main" tab.

Thanks

Steve

Sumif
 

Look in the help index for INDIRECT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
Hi

Is it possible to use a value from a pull down in a SUMIF statement?

=SUMIF(Forecast!B2:B218,Main!K11,Forecast!F2:F218)

I would like Forecast to be replaced by M6 on the "Main" tab.

Thanks

Steve

Sumif
 

=SUMIF(INDIRECT("'" & Main!M6 & "'!B2:B218"),Main!K11,INDIRECT("'" & Main!M6
& "'!F2:F218"))

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hi

Is it possible to use a value from a pull down in a SUMIF statement?

=SUMIF(Forecast!B2:B218,Main!K11,Forecast!F2:F218)

I would like Forecast to be replaced by M6 on the "Main" tab.

Thanks

Steve