Countifs contains

Trying to count if a cell by criteria if another cell contains "device":

=COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31))

#INVALID OPERATION

Find more posts tagged with

Accepted answers

Adam Murphy

Try this: =COUNTIFS([eCOA Department]:[eCOA Department], CONTAINS("Device", @cell), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) This assumes Year# being replaced with an actual year.

Leibel S

@dharberts

Try the below:

=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))

All comments

Adam Murphy

Leibel S

@dharberts

Try the below:

=COUNTIFS([eCOA Department]:[eCOA Department],CONTAINS("Device",@cell), [Award Date]:[Award Date], @cell>=DATE(Year#, 3, 1), [Award Date]:[Award Date], @cell<=DATE(Year#, 3, 31))

dharberts

That worked thank you

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.