Issue with countif and find formula

04/21/21
Accepted

Hello, I am trying to have number of projects owned by Project manager


I have used this formula :

=COUNTIFS({Digital Project Portfolio Plage 1}; FIND("[email protected]"; @cell) > 0; {Digital Project Portfolio Plage 2}; "In Progress")

which is working well

But i am trying to use it with an email adress like [email protected], it is giving me a 0 value.

Any idea to avoid this issue with 3 args before the @?

Strange :-) and thx

Best Answer

  • MCorbinMCorbin Overachievers
    Accepted Answer

    It's working for me if I just set it up this way - the Find wasn't needed. But, is there more than 1 email address in your email address column (that's when you'd need Find)

    =COUNTIFS([Email Address]1:[Email Address]12, "[email protected]", Status1:Status12, "In Progress")

Answers

  • MCorbinMCorbin Overachievers
    Accepted Answer

    It's working for me if I just set it up this way - the Find wasn't needed. But, is there more than 1 email address in your email address column (that's when you'd need Find)

    =COUNTIFS([Email Address]1:[Email Address]12, "[email protected]", Status1:Status12, "In Progress")

Sign In or Register to comment.