Estimator_J
New Member
- Joined
- Nov 23, 2016
- Messages
- 4
Hello all,
I have one column in which state abbreviations are entered.
The second column has dollar amounts entered.
I want to add the sum of the dollar amount column, determined by the text of the state abbreviation column. i.e. total dollar value for each state.
Further, I only want unique dollar values summed. If the exact same (duplicate) value exists, I want it omitted from the sum.
Is this possible? Any assistance would be greatly appreciated!
I have one column in which state abbreviations are entered.
The second column has dollar amounts entered.
I want to add the sum of the dollar amount column, determined by the text of the state abbreviation column. i.e. total dollar value for each state.
Further, I only want unique dollar values summed. If the exact same (duplicate) value exists, I want it omitted from the sum.
Is this possible? Any assistance would be greatly appreciated!