Hello,
I would like to know how to create a formula that 'reads' all filled in cells from row A, and shows a total of filled in cells in A150.
Hope it is clear what my question is.
Waiting for answers
Hello,
I would like to know how to create a formula that 'reads' all filled in cells from row A, and shows a total of filled in cells in A150.
Hope it is clear what my question is.
Waiting for answers
Last edited by jeroenheki; 10-12-2012 at 06:24 AM.
=counta(a1:a149)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
it only counts when in for example A5 contains numbers.. not text
Not correct!
COUNTA, counts all cells that have Number OR text.
ok sorry, thought it was a typo :D
thread solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks