# Count if & Unique Values?

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")

Tags:

• ✭✭✭✭✭

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.

Thanks & Regards

Khasim

SSPM Consultants

Email ID: info@sspmconsultants.com

Did I answer to your question or fix the problem? Please `help` the `Smartsheet Community` by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

• ✭✭✭✭✭✭

Try this,

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

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.

Thanks & Regards

Khasim

SSPM Consultants

Email ID: info@sspmconsultants.com

Did I answer to your question or fix the problem? Please `help` the `Smartsheet Community` by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!