Countifs Find Formula Help

Hello! I'm working on a formula to capture individuals involvement on projects. I currently have the following formula set up to track projects:

=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0)

I would like to add a condition to this so the formula only looks at projects with a status of "In Progress". I've tried adding another "If" statement to the formula but keep getting an error message. Does anyone know if/how I can add this condition to the formula?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Leibel S

@anuelle

See below, you can keep on adding ranges and criteria... Add/setup the cross sheet reference as needed

=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0,{Project Status},@cell="In Progress")

Ipshita

Hi @anuelle,

Try this formula - it will work :)

=COUNTIFS(Owner@row, FIND("Sofia", @cell) > 0, Status@row, "In Progress")

Hope this helps,

Cheers!

Ipshita

anuelle

@Leibel S I've tried your suggestion and am still getting an "Incorrect Argument Set" error. Could this be due to the fact it's a cross-reference formula?

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.