# Multiple Columns with possible answers using sumif(s)

Options
✭✭✭✭✭
edited 06/23/22

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.

• ✭✭✭✭✭✭
Options

Are you able to provide screenshots for reference?

• ✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!