Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count nonblank cells in rows within Excel?
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
How do I get excel to "count" cells along a row? | Excel Discussion (Misc queries) | |||
Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |