Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 159
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi. I have 4 different columns with different criteria and totals. I want to make a drop down that will then feed into a summary total table based upon selecting various criteria in a drop down. Is there a formula I can use to sum the totals for whatever criteria may be chosen from the drop down without having to write a long formula of sumifs?
The drop down would be Based on the aboveTo select either A, B, C, or D independently or do various combinations such as A & B, B & C & D, and so on. Is there a formula to do such a total sum based on any type of combination that may be requested?
I want to make this as user friendly as possible as this will be for management to use and they may want to see any type of combination from the table; so ideally I am trying to make this as an input for them to select and then the summary beside the drop down would display the answer.
A | B | C | D |
Total | Total | Total | Total |
250 | 500 | 650 | 700 |
The drop down would be Based on the aboveTo select either A, B, C, or D independently or do various combinations such as A & B, B & C & D, and so on. Is there a formula to do such a total sum based on any type of combination that may be requested?
I want to make this as user friendly as possible as this will be for management to use and they may want to see any type of combination from the table; so ideally I am trying to make this as an input for them to select and then the summary beside the drop down would display the answer.