I'm having a stupid day. Can somebody please help me out?
I have a spreadsheet and I want to count all the cells in a column that are not blank.
What function/operator do I need please?
Thanks :o
Ben
Printable View
I'm having a stupid day. Can somebody please help me out?
I have a spreadsheet and I want to count all the cells in a column that are not blank.
What function/operator do I need please?
Thanks :o
Ben
COUNTA(B1:B5)
where B1:B5 is your range.
Ref:
http://www.contextures.com/xlFunctions04.html#CountA