Thread: count cells that have something in it
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default count cells that have something in it
=COUNTIF(A1:A8,"<""")

"delete automatically" wrote:

How do I count cells that have something in it? For example if A1,A4,A7,A8
has anything in it the I want cell A20 to say 4
Reply With QuoteReply With Quote