| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting-type formula
Is there a formula that makes a cell state a number that correlates to the
number of cells in selected area that have data entered into them? I hope this makes sense, I'm having trouble articulating what I mean... Thank you in advance for any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting-type formula
=COUNTA(A1:A10)
-- Gary''s Student - gsnu200902 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting-type formula
So you want to get a count of cells with values in a range.
=COUNTA(A:A) will give all cells in column A that have values. =COUNT(A:A) will count only cells that are numeric. "Kristen" wrote: Is there a formula that makes a cell state a number that correlates to the number of cells in selected area that have data entered into them? I hope this makes sense, I'm having trouble articulating what I mean... Thank you in advance for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting type of incidents | Excel Worksheet Functions | |||
| Counting cells with a particular type formatting | Excel Discussion (Misc queries) | |||
| Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
| Not sure what type of Formula to use... | Excel Discussion (Misc queries) | |||
| Counting&Sorting multiple serial numbers per machine type | Excel Discussion (Misc queries) | |||
Hybrid Mode
