I want to have a cumulative COUNTIFS. I want it to countif "criteria 1" is there and then add another one to the count if "criteria 2" is present and add another one to the count if criteria 4 is present so in the end I can get a total of 3 in the cell and not one.
Now lets say I have a category column titled Teachers and I wanted to count how many teachers where in that cell.
So CEll A3 = Language Arts Teacher
my count ifs would be =COUNTIFS(A2:A4,"*" & "Language Arts Teacher" & "*",J2:J4,"School A") + =COUNTIFS(A2:Af4,"*" & "Math Teacher" & "*",J2:J4,"School B") + ....etc
What formula do I great so it can scan the cell and count the 3 teachers total ?