Topic starter
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?
Posted : 03/09/2017 10:48 am
Quick thought would be do an B1=If(A1="","XX",A1) then do your COUNTIF on B
Posted : 03/09/2017 10:52 am
I would use something along the lines of:
=COUNTIFS(A:A,"text",B:B,<>"")
Posted : 03/09/2017 11:09 am
Use this
=COUNTIFS(A:A,"Text",B:B,"=*")
But don't use full column references cos it makes me cry 
Posted : 03/09/2017 11:17 am
Topic starter
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!
Posted : 03/09/2017 11:55 am