Referencing when a column says HR and the date is this year
=COUNTIF({Intake Archival Range 1}, "HR", AND({Intake Archival Range 3}, >=DATE(2022, 1, 1)))
Any help appreciated!
Hello. Try this if will works.
=COUNTIFS({Intake Archival Range 1}, "HR", {Intake Archival Range 3}, @cell DATE(2022, 1, 1))
Hi Jessica,
You would want to use the COUNTIFS function:
=COUNTIFS({Intake Archival Range 1}, "HR", {Intake Archival Range 3}, >=DATE(2022, 1, 1))
Hope this helps!
@Tim Dollmeyer #incorrect argument
@RaffyM #unparseable
Any other ideas?
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
