Using SUMIF with a drop down.

[Steve]

Hi, I think I put tis in the wrong area before.

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, this would
give me the ability to do the calculations for all tabs.

Thanks

Steve

 

[Luke M]

I'm assuming M6 will contain the name of a sheet?

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

 

[Steve]

Hi Luke

Worked a treat, many thanks

Steve

I'm assuming M6 will contain the name of a sheet?

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


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*