Multiple Columns with possible answers using sumif(s)

liz.mayeux ✭✭✭✭✭
edited 06/23/22 in Formulas and Functions

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!