MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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!