Hi,

I am just trying to write a formula that counts the number of non-blan
cells in a column.

E.g. In column G, i know there are 166 populated cells, but this coul
change. So how can a formula calculate this authomatically?

Any ideas

--
Message posted from http://www.ExcelForum.com

hi
you can try this out.

dim i
for i = 1 to columns.count
if len(cells(7,i).value) 0 then
count=count+1
end if
next

where count is the count of the populated cells

I beleive this is what you want

Thanks
venkatesh


--
Message posted from http://www.ExcelForum.com

=countA(G:G)

--
Regards,
Tom Ogilvy

"nic17 " wrote in message
...
Hi,

I am just trying to write a formula that counts the number of non-blank
cells in a column.

E.g. In column G, i know there are 166 populated cells, but this could
change. So how can a formula calculate this authomatically?

Any ideas?


---
Message posted from http://www.ExcelForum.com/

Great, Thanks a lo

--
Message posted from http://www.ExcelForum.com

Nic,

try:

=COUNTA($G:$G)

Cheers, Pete.

-----Original Message-----
Hi,

I am just trying to write a formula that counts the
number of non-blank
cells in a column.

E.g. In column G, i know there are 166 populated cells,
but this could
change. So how can a formula calculate this
authomatically?

Any ideas?


---
Message posted from http://www.ExcelForum.com/

.