Sumif

[Steve]

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

 

[Don Guillett]

Look in the help index for INDIRECT

 

[Jacob Skaria]

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

If this post helps click Yes