psycoperl
Active Member
- Joined
- Oct 23, 2007
- Messages
- 338
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
- Web
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?
I was working with the following formula and it did not work. Not sure what I am doing wrong?
Excel Formula:
=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 |