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
Check out the Formula Handbook template!