All classes KS3 and KS4BLANK.xlsx
Hi all am new to using COUNTIFS. I am trying to make a formula to find all in column B that have the word ABOVE and that also have either and S, A, or P in column D.
I tried =countifs(B5:B235,"Above",D5:D235,{"S","A","P"})
Can anyone help?
Bookmarks