Countifs with multiple variables.

Tammy May

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... :-)

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()))

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.