Hi. I'm at wits end trying to figure out what I'm doing wrong (I have to believe this is possible). I have multiple scenarios I need to pick to sum various elements of a table. There are 14 scenarios to sum, so a nested IF statement would be extremely painful. Attached is a sample of the file, where I may want to sum "Base" only, or "Base" and "EDI", all three, or other combinations (of the sample; the real version is much more expansive).
I would like to set up a drop-down of options, which would then sum Column D. The solution will also be applied to summing a few other columns as well.
I've tried referencing the cell with bracketed text, SHIFT+CTRL+ENTER, and other things.
Any help is appreciated. I've tried to do this before with something but couldn't figure it out so nested an IF statement. Now I need this with more options so nesting is something I am hoping to avoid.
I cannot use VBA to solve (I need the file to stay an XLSX).
Thank you in advance.
I would like to set up a drop-down of options, which would then sum Column D. The solution will also be applied to summing a few other columns as well.
I've tried referencing the cell with bracketed text, SHIFT+CTRL+ENTER, and other things.
Any help is appreciated. I've tried to do this before with something but couldn't figure it out so nested an IF statement. Now I need this with more options so nesting is something I am hoping to avoid.
I cannot use VBA to solve (I need the file to stay an XLSX).
Thank you in advance.