Countifs with multiple variables.

I'm trying to count the number of each Request Type for the current month based on the Created Date pulling data from the Sheet - Engagement Request Tracking with Form.

Here's a picture of my source sheet:

Here's a picture of my sheet to capture the totals:

If tried using several formulas and can't seem to come up with anything that seems to work. Here's one of the formulas I tried:

=COUNTIFS({Sheet - Engagement Request Tracking with F Range 1}, Category@row, [{Sheet - Engagement Request Tracking with f Range 4}, IFERROR(MONTH(@cell), 0) = Month(Today())])

Any suggestions? I'm still learning so please keep that in mind... :-)

Find more posts tagged with

Accepted answers

Mike Wilday

I think you're pretty close. I don't know about the IFerror, but it looks alright without the brackets.

=COUNTIFS({Sheet - Engagement Request Tracking with F Range 1}, Category@row, {Sheet - Engagement Request Tracking with f Range 4}, IFERROR(MONTH(@cell), 0) = Month(Today()))

All comments

Mike Wilday

I think you're pretty close. I don't know about the IFerror, but it looks alright without the brackets.

=COUNTIFS({Sheet - Engagement Request Tracking with F Range 1}, Category@row, {Sheet - Engagement Request Tracking with f Range 4}, IFERROR(MONTH(@cell), 0) = Month(Today()))

Tammy May

Thank you...I was almost there. This worked.

Mike Wilday

Yep, smartsheets help documents use brackets to show optional data but sometimes it looks like you need to add them. :) I'm glad I could help you out.

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.