Sum one column based on the unique value in another column

G

Guest

I have the following columns:

Account# - # of Account Holders - # per State
12345 - 3 - 2 in VA
12345 - 3 - 1 in MD
23456 - 1 - 1 in PA


In this example, I need to show that there are 2 Total Accounts with 4 total
account holders

I have used the following to show the total of unique account numbers:
=SUM(IF(FREQUENCY(MATCH(Data!D2:D91,Data!D2:D91,0),MATCH(Data!D2:D91,Data!D2:D91,0))>0,1))

How do I SUM Column B based on unique values in Column A?

Thank you much!
Renee
 
B

Bernard Liengme

I would be tempted to make a pivot table with Accounts in the Row area,
Holders in the Column area and Holders COUNTED in the data area.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Count Unique Values in a entire column, not just range 20
Count unique values in one column if values in corresponding columnare null? 1
Summing/Counting Data in One Column Based on Criteria Another Col 2
count unique in one column based on two other columns 4
count unique values in one column for a set value in another col. 2
match 1 column bringing in a value from another column 3
sum column based on single cell match? 1

Top