Countifs and countif w/ use of Distinction?

I have migrations that include dedicated customers and multi-tenant servers and so only want to count migrations for multi-tenants once. Would I use a countif and distinction? I looked at previous comments and can't seem to get that to work?

=COUNTIFS({AWS Migration Groupings-Comms Plan Range 4}, 1, DISTINCT({AWS Migration Groupings-Comms Plan Range 1}, "MT006P"))

I have a rollup sheet - and so am referencing a date helper column and then want to only count ONCE those customers that meet/have the name MT006P in that column. What am I doing incorrectly?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Sborror

    Would you be able to post a screen capture of the source sheet (but block out sensitive data).

    You could use a COUNT(DISTINCT(COLLECT formula to count rows, but I'm not sure I understand what it is you're counting in terms of the criteria.

    Do the cells contain MT006P or do they equal MT006P?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!