Help! Cannot get COUNTIFS formula to work

KUMDC
KUMDC ✭✭✭
edited 04/06/23 in Formulas and Functions

@Paul Newcome I am trying to count the number of occurrences of the "Deliverable Type" with a quarterly date range (i.e., January to March, April-June, July-September, October-December). I have read through and tried following this thread and trying a different combination of formulas suggested by you but apparently I am doing something very wrong. FYI, the data is coming from a reference sheet (see picture) and the date field is formatted as a date.

This is the last formula I tried and it also resulted in the result of #UNPARSABLE as have all of the others I have tried.

=COUNTIFS({Hardee, Highlands Data Range 4}, [Deliverable Type]=[T2: Training Parents, Teachers, School Personnel, and Community interagency, fairs, etc], AND([Date of Service]:[Date of Service], AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2022), AND((IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2022))

The reference fields I am trying to count and range I am trying to use are highlighted. Eventually I would like it to pull this info same from a total of 5 pages to give me a combined total for the quarter. Please let me know if you need any other information! Thank you!!!


Best Answer

Β«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!