-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sum unique
-
SUM on unique/distinct fields only
I've found several post that SHOULD have answered this question but I can't quite get them to work for me. Probably because they are all array formulas and I'm just not that good with those. So here is my exact situation. In column A I have 'AccountNumbers' and in column O I have 'Balances' in...- badinvestor
- Thread
- sum unique
- Replies: 1
- Forum: Excel Questions
-
J
combining unique values
Part 1 I would like to take info in a column and get a list of unique values eg: tom dave bob dave dave tom tom dave tom bob WOULD BECOME: tom dave bob NOTE: the data is contained on SHEET1 and i will have the formula on SHEET2 PART 2 I would like to sum up the values in column B for...- joldfield101
- Thread
- formula sum sum unique unique entries
- Replies: 1
- Forum: Excel Questions
-
W
Sum Unique Values Multiple Criteria
I am trying to sum unique values based on two criteria using the below formula but it is returning incorrect result. The formula does work because when I try in on a small (11 rows) of test data it works and correct results are returned but when I add it to my larger production data (6000+ rows)...- Wannabeanexcelexpert
- Thread
- excel multiple criteria sum unique
- Replies: 3
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
