Forum Discussion
SumIF excluding duplicates and Errors
Hello, I am having trouble writing the formula to only capture unique values, with multiple columns. I know that the answer is- 900 Yes or No ID Value Yes 50262146 300 No 50484...
hurshie , can you clarify?
Unique Yes is only 2 rows and add up to 600. Am I thinking about this wrong since I don't see the 900 you get?
| Yes or No | ID | Value |
| Yes | 50262146 | 300 |
| Yes | 18632031 | 300 |
Yes apologies, i was in a rush and set this up incorrectly.
I cant figure out how to sum all the highlighted in red is 800
As you can see below. I am trying to write a function that states If first column states YES, ID is unique, Sum the value to equal 800. I want it to ignore the duplicate ID's and #N/A's
300+300+200 = 800
Yes or No ID Value Yes 50262146 300 No 50484138 100 Yes 50262146 300 Yes 18632031 300 Yes 23501649 200 Yes 50262146 300 No #N/A #N/A Does that help?
