COUNTIFS and DISTINCT formula error


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!