Multiple Columns with possible answers using sumif(s)
I'm really not sure which formula or combination of formulas i should be using. I need this to be embedded because i'm already curating over 50 columns in this sheet i just can't see managing much more.
Column 1, 3, 5, 7 have drop down choices A, B, C, D
Column 2, 4, 6, 8 have free text for numbers
I have total columns for each drop down choice
Column A Total
Column B Total
Column C Total
Column D Total
I want to have a formula in each TOTAL Column that looks at Column 1,3,5,7 and brings back the total of the free text numbers if they equal that particular column.
So if Column 1 = A, Column 3 = A, Column 5 = C, Column 7 = D
Column 2 = 5, Column 4 = 5, Column 6 = 20, Column 8 = 1
Then I would like to see the following results. Please note that these are totaled across the same row.
Column A Total = 10
Column B Total = 0
Column C Total = 20
Column D Total = 1
I hope I'm explaining this well enough. Any help would be appreciated.
Answers
-
Are you able to provide screenshots for reference?
-
I was getting ready to pull this question down. I figured out that i should group all my similar columns together and then create sum if formulas. For some reason it is working. Some of that SS magic happening today.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!