Formula help!

[nic17]

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

 

[kvenku]

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

 

[Tom Ogilvy]

=countA(G:G)

 

[nic17]

Great, Thanks a lo

 

[Pete McCosh]

Nic,

try:

=COUNTA($G:$G)

Cheers, Pete.