How do I count nonblank cells in rows within Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
See if either the COUNTA or COUNTIF function gets you where you want to be.

Does that help?

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

XL2002, WinXP-Pro
 
Back
Top