View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Obtaining & using last cell in a column in a cell formula

=COUNTIF(G:G,"0")-COUNTIF(G1:G3,"0")


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"mikeburg" wrote in
message ...

Thanks. I thought of that, but I do not want to include the 1st three
rows in column G.

Any other ideas?

mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:

http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=545563