Hi everyone,
Been sitting for over an hour and tearing my hair out now, so just had to ask.
I have a column which calculates a percentage value. On this column I use an IFERROR and "" to return a blank cell where I get errors. Typically, this is the bottom row or two.
My problem is that I want to count the numbers in this column and Excel counts the cells containing text also. I also want the count to be conditional and count only if variable Order = HL in some other column. I've tried various COUNTIFS and just can't seem to get it correct:
COUNTIFS(OFFSET(G10,0,0,E6),"HL",OFFSET(H10,0,0,E6),"<>"& "")
You may want to ignore the OFFSET part, but observe the "<>"&"" for my attempt on counting everything which is not text.
What am I missing?
Thanks in advance!
Elijah
Uten navn.png
Bookmarks