I have currently got a table that refers to a data spreadsheet to count learners, I have got the formula set up when a column contains Green, Amber or Red but I can't figure out what the formula should be if the column is blank.
The formula I currently have in J9 is:=COUNTIFS(Learners!$K:$K,Summary!I$8,Learners!$T:$T,Summary!$B9,Learners!$A:$A,">=2018-2019",Learners!$AY:$AY,Summary!$B$5), where Summary is the spreadsheet below and Learners is the spreadsheet with the data.
The formula I currently have in J9 is:=COUNTIFS(Learners!$K:$K,Summary!I$8,Learners!$T:$T,Summary!$B9,Learners!$A:$A,">=2018-2019",Learners!$AY:$AY,Summary!$B$5), where Summary is the spreadsheet below and Learners is the spreadsheet with the data.
A | B | C | D | E | F | G | H | I | J | |
1 | ||||||||||
2 | ||||||||||
3 | ||||||||||
4 | ||||||||||
5 | Supply Chain | |||||||||
6 | ||||||||||
7 | ||||||||||
8 | Course | Live | Comp | Leaver | Blank | Green | Amber | Red | Blank | |
9 | Level 2 Ware |
<tbody>
</tbody>