Countifs and countif w/ use of Distinction?

Sborror

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.

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?