COUNTIFS on Summary Sheet for a Given Date

Jazzy

Hello,

I am wanting to count survey results for my summary sheet. In the example below I want to count the results after a certain date where communication = "No Concerns". I am receiving an #INVALID OPERATION ERROR when I submit the code below:

=COUNTIFS([Evaluation Date]:[Evaluation Date] > DATE(2024, 7, 1), Communication : Communication, "No Concerns")

Thanks in advance!

Regards,

Jeffrey

heyjay

Missing Comma after your first Range

=COUNTIFS(
[Evaluation Date]:[Evaluation Date], >DATE(2024, 7, 1), 
Communication:Communication, "No Concerns")

Leroy Noriega

Looks like Communication:Communication is missing []

Try:

=COUNTIFS([Evaluation Date]:[Evaluation Date] > DATE(2024,7,1), [Communication:Communication], "No Concerns")

Jazzy

I am receiving an UNPARSEABLE error when I submit the recommended code.

heyjay

Missing Comma after your first Range

=COUNTIFS(
[Evaluation Date]:[Evaluation Date], >DATE(2024, 7, 1), 
Communication:Communication, "No Concerns")

Jazzy

Thanks so much!