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.
