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"))

 

[Shane Devenshire]

Hi,

Its not clear what you want but it sounds like Data, Validation.

Hi,

Here are the basic steps for applying Data Validation to a range:

1. Select M6 on the main tab
2. Choose Data, Validation and open the Allow drop-down
3. Select List and highlight a range where you list the name of each sheet
4. The modify your SUMIF formula something like this:

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

If the formula is not on the Main sheet then you will need to change the M6
reference to something like Main!M6 in the above formula.

 

[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!*