Countifs with isblank

[davin1130]

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))

 

[hajiali]

I think this is what you asking for Try this

=COUNTIFS('Raw Data'!!$A$4:$A$8000,">="&C1,'Raw Data'!$A$4:$A$8000,"<="&C2,'Raw Data'!$Q$4:$Q$8000,"")

Let me know

 

[davin1130]

I think this is what you asking for Try this

=COUNTIFS('Raw Data'!!$A$4:$A$8000,">="&C1,'Raw Data'!$A$4:$A$8000,"<="&C2,'Raw Data'!$Q$4:$Q$8000,"")

Let me know

Thank you for the help, however, i'm getting a count of zero and i know that it is incorrect.

 

[hajiali]

sorry I had an extra "!" in the formula try this:

COUNTIFS('Raw Data'!$A$4:$A$8000,">="&C1,'Raw Data'!$A$4:$A$8000,"<="&C2,'Raw Data'!$Q$4:$Q$8000,"")

 

[davin1130]

sorry I had an extra "!" in the formula try this:

COUNTIFS('Raw Data'!$A$4:$A$8000,">="&C1,'Raw Data'!$A$4:$A$8000,"<="&C2,'Raw Data'!$Q$4:$Q$8000,"")

I noticed the extra ! earlier ... Still getting zero results ... i looked through the data and there are 86 items that should be getting picked up with this search.

 

[hajiali]

WorkbookY.xlsm
	A	B	C
1	10		1/1/2022
2			1/15/2022
Sheet6

Cell Formulas
Range	Formula
A1	A1	=COUNTIFS('Raw Data'!$A$4:$A$8000,">="&C1,'Raw Data'!$A$4:$A$8000,"<="&C2,'Raw Data'!$Q$4:$Q$8000,"")

This is what I have. if you want please xl2bb what you have.