Hi
I need to add a sumifs criteria to a match index formula to list unique values from a column.
unique.JPG
with formula in D2:
I don't want the unique list to report the number 44 since the sum of amount with the number 44 is 0 (1-1=0). How would you solve this?Please Login or Register to view this content.
Bookmarks