Count and Distinct Formula returns 1

Options
lschek1
lschek1 ✭✭
edited 05/06/22 in Formulas and Functions

Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so I expected an error in the grand total as well, but I have no clue.

The total value excluding duplicates should be 475.

Best regards,

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!