Forum Discussion
How to count the total value of unique items
Hello! Hoping someone can help. I have a spreadsheet of data that lists projects that come to my team for review/approval. Every time a project comes to us, we are recording the project name, if it...
I assume, you need GROUPBY() function. See the attached file and let us know your feedback.
=GROUPBY(B2:C17,D2:D17,SUM,3,1)
Not quite, this looks like you are totally the value of the same project within the same stage. I am trying to remove those as duplicates and only total non duplicative projects.
