Hi - first posting in here. I have a range ab862:ab891 which has one of the following text strings entered into the cell range:
no data
no day shift data
no night shift data

I need to be able to count how many cells have any of these statements in the cell range. Ive tried countifs, sumproduct from other posts but im not making it work somehow...

=COUNTIF(AB862:AB891,"no data") works fine with any of the statements one at a time
=COUNTIFS(AB862:AB891,"no data", "no day shift data") returns the help dialog box
=SUMPRODUCT(--(AB862:AB891="no data"), --(AB862:AB891="no night shift data")) returns no error and doesnt return a result other than zero
=COUNTIFS(AB862:AB891,"no data",AB862:AB891,"no night shift data") doesnt return any errors, but it doesnt return a result other than zero either...

Please help I'm stumped...