Doesn't seem to work. I've adapted it to suit me using B10:B:9999 and i counted 1248 entries
A alexm999 Oct 20, 2004 #1 Doesn't seem to work. I've adapted it to suit me using B10:B:9999 and i counted 1248 entries
S scott Oct 20, 2004 #2 Did you try this? =COUNTA(B10:B9999) Are the cells actually blank, or is there something in the cell like a space? =ISBLANK(B17) ( put a cell that appears to be blank in the formula and it will either show true if blank, or false if something is in the cell)
Did you try this? =COUNTA(B10:B9999) Are the cells actually blank, or is there something in the cell like a space? =ISBLANK(B17) ( put a cell that appears to be blank in the formula and it will either show true if blank, or false if something is in the cell)
