Sum based on multiple drop-down list in Excel

June 11, 2017 at 10:38:49
Specs: Windows 7

Column A4 to A8 have drop down list option from Rune 1.
Column B4 to B8 have drop down list option from Rune 1.

Column D4 to D8 have drop down list option from Rune 2.
Column E4 to E8 have drop down list option from Rune 2.

I need the sum of the total VALUE of a specific STAT chosen on both RUNES and don't know the formula.

Please need help


See More: Sum based on multiple drop-down list in Excel

Report •

#1
June 11, 2017 at 19:26:36
I have no idea what "RUNE" or a "STAT" is.

If all you want is a SUM, why not just sum the cells that contain the choices made from the drop downs?

You probably need to provide some more details, keeping in mind that we can't see your spreadsheet from where we are sitting nor do we know how you use the spreadsheet.

Please try to explain your requirements in generic Excel terms, not terms related to your work because we don't know what those terms mean.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question