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
Bookmarks