Thread: Counta
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Darrell_Sarrasin via OfficeKB.com Darrell_Sarrasin via OfficeKB.com is offline
external usenet poster
 
Posts: 66
Default Counta

Sorry it does not work

THe column has a formula sitting in it so that there is nothing displayed if
what its pulling from is blank.

Need something to ignore the formula in each cell unless there is output
printed. and hte output is text.

Sean Timmons wrote:
=counta(column)-countblank(column)

I hve been fighting with this for the last week or so. I have a column which
has the potential to show 100 items. it is a basically filled in with a

[quoted text clipped - 4 lines]

Can I get help on how to make it so it ignores the cells with a formula


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1