I'm trying to count all of the blank cells in column Q provided they fall within the date range of C1 to C2
Sheet 'Raw Data' column A are dates
Sheet 'Raw Data' column Q are times
C1=start date range
C2=end date range
I've tried the following, but i get an error of #Spill!
=IF(ISBLANK('Raw Data'!Q4:Q8000),COUNTIFS('Raw Data'!A4:A8000,">="&C1,'Raw Data'!A4:A8000,"<="&C2))
Sheet 'Raw Data' column A are dates
Sheet 'Raw Data' column Q are times
C1=start date range
C2=end date range
I've tried the following, but i get an error of #Spill!
=IF(ISBLANK('Raw Data'!Q4:Q8000),COUNTIFS('Raw Data'!A4:A8000,">="&C1,'Raw Data'!A4:A8000,"<="&C2))