Unique Count based on @cell

kgahm7569

I'm trying to count the number of EIDs associated with each New Area.

Below I would hope htat next to Metro New York I would get a 2 and Gulf Coast I would get a 3

che.rabajante

Hello @kgahm7569

You can use the countif function in New Area instead of EID to get the correct value.

=COUNTIF([New Area]:[New Area], "Gulf Coast")

Hope this helps.

che

che.rabajante

Hello @kgahm7569

You can use the countif function in New Area instead of EID to get the correct value.

=COUNTIF([New Area]:[New Area], "Gulf Coast")

Hope this helps.

che

kgahm7569

Thanks. I realized it was the way the value was pivoting in. When I was looking for hte criteria it has a ' apostrophie and I didn't realize it was hiding.

Thank you so much.