I need help from the STW Excel masters.

I’m trying to do a COUNTIFS based on certain text being in column A and only counting non-blank cells in column B. I can’t for the life of me find the correct expression for ignoring the blanks / only counting the cells wich are populated in column B 🙁

It’s going to be something ridiculously simple isn’t it?

Quick thought would be do an B1=If(A1=””,”XX”,A1) then do your COUNTIF on B

I would use something along the lines of:
=COUNTIFS(A:A,”text”,B:B,<>””)

Use this

=COUNTIFS(A:A,”Text”,B:B,”=*”)

But don’t use full column references cos it makes me cry

Thanks guys. I knew this place wouldn’t let me down 😀

Oddly enough I tried <> originally and it threw a wobbly. Worked this time though!