Count Unique Cells that meet a certain criteria

Philip Arnfield · 01/03/21

I am looking for a formula to count the number of items - "Sales - Service Labour" occur in a series, on unique invoice numbers.

I have tried this formula with no success

=COUNTIFS(DISTINCT([Invoice Number]:[Invoice Number]), Account:Account, "Sales - Service/Labour")

Kelly Moore · 01/03/21

Hi

Try this

=COUNT(DISTINCT(COLLECT([Invoice Number]:[Invoice Number], Account:Account, "Sales - Service/Labour")))

cheers,

Kelly

Kelly Moore · 01/03/21

Hi

Try this

=COUNT(DISTINCT(COLLECT([Invoice Number]:[Invoice Number], Account:Account, "Sales - Service/Labour")))

cheers,

Kelly

Mark Cronk · 01/03/21

Philip Arnfield · 01/03/21

Thanks Kelly, that worked, much appreciated.

Philip

Philip Arnfield · 01/03/21

Hi Mark, thanks for your contribution, which I can't seem to see now. I liked your approach because it reduces the complexity of the process

Mark Cronk · 01/03/21

Hi Phil, I removed my response when I saw that Kelly already answered with an awesome solution. I learned how to do COUNT(DISTINCT(COLLECT..

Mark

Best Answer