View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default How do I count nonblank cells in rows within Excel?

See if either the COUNTA or COUNTIF function gets you where you want to be.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JoJo" wrote:

I want to create a spreadsheet in Excel, inwhich entries are ticks or blanks.
I then want to count the number of ticks in each row. How do I do this? The
help function only describes counting columns, and I haven't found that these
instructions work with rows.