Hello,

I am missing something, I just can't see what.

I want to count any cells with data in AC, if the adjacent column E:E is between the date range found on C3 and J3.


=COUNTIFS('Survey Data'!AC:AC,'Survey Data'!E:E,">="&Summary!$C$3,'Survey Data'!E:E, "<="&Summary!$J$3)

I am getting too few arguments, I just can't see what.

I appreciate any help.

Nick