COUNTIFS with multiple contacts in the same cell then reference a second column

Hi,

=COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell), [Project Type]:[Project Type], "LV Switchgear")

I am trying to create a summary which shows how many of a certain project type a project manager may be involved in. Hope that makes sense

I can get the first part of the formula to work on its own..

=COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell))

but as soon as I add the criteria for the second column, namely the Project Type, it returns a 0 value

Please see picture below.

Can anybody help please?

Find more posts tagged with

Formulas

help

Accepted answers

All comments

Nic Larsen

Try it like this:

=COUNTIFS([24-7 PM]:[24-7 PM], FIND("Jon Cornwell", @cell) >0, [Project Type]:[Project Type], "LV Switchgear")

Edit - this should also work:

=COUNTIFS([24-7 PM]:[24-7 PM], HAS(@cell, "Jon Cornwell"), [Project Type]:[Project Type], "LV Switchgear")

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.