Issue with countif and find formula

Vincent TURLURE

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("xxxxx.xxxxx@xxxxxx.com"; @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 xxx.xxxx.xxxx@xxxx.com, it is giving me a 0 value.

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

Strange :-) and thx

Find more posts tagged with

Accepted answers

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, "Mel.Cor.Bin@email.com", Status1:Status12, "In Progress")

All comments

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, "Mel.Cor.Bin@email.com", Status1:Status12, "In Progress")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.