COUNTIFS and DISTINCT formula error

Options

Hello! I am trying to count the number of unique customers from one column, that have been flagged with the year 2022 which is recorded in a separate column.

Formula I have is -

=COUNTIFS(DISTINCT({Customer Name}, {Financial Year}, "2022"))

I am receiving the error, Incorrect Argument Set. Can someone help please?!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!