How do I count nonblank cells in rows within Excel?

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.
 
G

Guest

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

Does that help?

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Count number of text rows??? 3
counting nonblank rows 8
count nonblank cells 3
count how many rows contain nonblank in column A and blank in colu 5
Count NonBlank Rows with Criteria in another column 5
counting blank cells within two columns 2
Row Numbering 1

Top