Using SUMIF with a drop down.

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
I'm assuming M6 will contain the name of a sheet?

=SUMIF(INDIRECT(Main!M6&"!B2:B218"),Main!K11,INDIRECT(M6&"!F2:F218"))
 
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.
 
Hi Luke

Worked a treat, many thanks

Steve

Luke M said:
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!*
Click to expand...
 
Back
Top