Formula to find how many are cell is blank in a range?

[psycoperl]

I am working on a project where I want to find out how entries in worksheet 'Course Info' have blank values in column 'Course Info'!X when there is a value in Column 'Course Info'!A and then display it in the Instructions Worksheet Cell M6

I was working with the following formula and it did not work. Not sure what I am doing wrong?

=COUNTIFS('Course Info'!$A:$A,$A1<>"",'Course Info'!$X:$X,$X1<>"")

SCFE_Prep1_Sp21.xlsx
	G	H	I	J	K	L	M	N
1
2
3	File ID:	SCFE
4
5	Stats:	Sections To Be Reviewed		Crosslistings To Be Reviewed		Instructors Missing	Sections Missing Signature
6		10,096		10,096		0	0
7
Instructions

Cell Formulas
Range	Formula
H6,J6	H6	=COUNTIF('Course Info'!Q:Q,"[-] NEEDS RESPONSE")
L6	L6	=COUNTIF('Course Info'!K:K,"00000000")
M6	M6	=COUNTIFS('Course Info'!$A:$A,$A1<>"",'Course Info'!$X:$X,$X1<>"")

Named Ranges
Name	Refers To	Cells
'Course Info'!_FilterDatabase	='Course Info'!$A$2:$Z$10098	M6

SCFE_Prep1_Sp21.xlsx
	A	B	C
2	Class Nbr	Inst Nbr	Discipline
3	1205
4	10009
5
6
Course Info

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:AF100098	Expression	=OR(ISNUMBER(SEARCH("[-]",$Q3,1)),ISNUMBER(SEARCH("[-]",$S3,1)))	text	NO

SCFE_Prep1_Sp21.xlsx
	X	Y	Z
2	Name	Title	Date
3
4
5
6
Course Info

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:AF100098	Expression	=OR(ISNUMBER(SEARCH("[-]",$Q3,1)),ISNUMBER(SEARCH("[-]",$S3,1)))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
Z2:Z6	Date	>9/1/2020

 

[jasonb75]

try

=COUNTIFS('Course Info'!$A:$A,"<>",'Course Info'!$X:$X,"")

 

[psycoperl]

try

=COUNTIFS('Course Info'!$A:$A,"<>",'Course Info'!$X:$X,"")

Worked! Thank you

 

[kweaver]

COUNTIFS needs to have the range separated from the criteria with a comma.

 

[jasonb75]

COUNTIFS needs to have the range separated from the criteria with a comma.

If you're referring to the OP's original formula then it was comma separated, but they had included the first cell of the range in the criteria as well.
I've seen the same a few times in old threads where a member has tried to write countifs formulas using a method of =COUNTIFS(applies to range, condition based on first cell) thinking that it works similarly to conditional formatting.

 

[psycoperl]

If you're referring to the OP's original formula then it was comma separated, but they had included the first cell of the range in the criteria as well.
I've seen the same a few times in old threads where a member has tried to write countifs formulas using a method of =COUNTIFS(applies to range, condition based on first cell) thinking that it works similarly to conditional formatting.

@jasonb75 exactly what I was modeling my formula based on. Good to know now.