Countif based on date range in adjacent column

[nickpavlov]

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

[alansidman]

Are your dates real Excel dates and not text that look like dates?

[etaf]

you have 2 ranges together , almost like a SUMIFS () , rather than a countifs( criteria_range1 , criteria1 , criteria_range2 , criteria2 ......)
'Survey Data'!AC:AC,
'Survey Data'!E:E,

whats 'Survey Data'!AC:AC, doing ?

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


if non blank TRY

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

[etaf]

i have added a spreadsheet - without the sheet names for simplicity
=COUNTIFS('Survey Data'!AC:AC,'Survey Data'!E:E,">="&Summary!$C$3,'Survey Data'!E:E, "<="&Summary!$J$3)

in A1
=COUNTIFS(B:B, "<>", E:E,">="&$C$3,E:E, "<="&$J$3)

[nickpavlov]

Thank you etaf,

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

This worked for me.

[etaf]

you are welome