Forum Discussion
Solved
Formula to countif one column based on a word in another
Not sure if that title explains it very well! I've tried googling around and using nested IF/Countif functions but I've not had any luck so far. BACKGROUND: I have a table, and I use it to creat...
- I'm silly - I tried just CountIfs at the start with no luck, but I went back to it and it worked this time, so I must have just got the syntax or something wrong first time round.
To confirm, the formula I was looking for was:
"=COUNTIFS(Table1[LAB01], "Not applicable", Table1[College], "CLES")"
I'm silly - I tried just CountIfs at the start with no luck, but I went back to it and it worked this time, so I must have just got the syntax or something wrong first time round.
To confirm, the formula I was looking for was:
"=COUNTIFS(Table1[LAB01], "Not applicable", Table1[College], "CLES")"
To confirm, the formula I was looking for was:
"=COUNTIFS(Table1[LAB01], "Not applicable", Table1[College], "CLES")"