Hi Luke

Worked a treat, many thanks

Steve

"Luke M" wrote:

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

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


--
Best Regards,

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


"Steve" wrote:

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