Count Unique Cells that meet a certain criteria

Philip Arnfield

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

Hi

Try this

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

cheers,

Kelly

Kelly Moore

Hi

Try this

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

cheers,

Kelly

Mark Cronk

Philip Arnfield

Thanks Kelly, that worked, much appreciated.

Philip

Philip Arnfield

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

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