Count if & Unique Values?

Jacob Jennings

Hi!

I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates.

Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10 times (100 performance emails have been produced). Any guidance is appreciated!

My formula is as follows: =COUNTIFS(DISTINCT([item]:[item]), ,[frequency]:[frequency],"monthly")

Khasim

Hi @Jacob Jennings

You're almost there, but instead of COUNTIFS, you should use COUNT

=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))

Thanks @Sameer Karkhanis for the quick response.

Sameer Karkhanis

Try this,

=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly"))) 

Khasim

Hi @Jacob Jennings

You're almost there, but instead of COUNTIFS, you should use COUNT

=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))

Thanks @Sameer Karkhanis for the quick response.