| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Help
I'm making a spreadsheet and I need to make my entry into a cell or row
equate a one, so that I can tabulate the total of entries rather than numbering...is that possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help
=counta(A1:A20)
will count all non-blank cells "needing help" wrote: I'm making a spreadsheet and I need to make my entry into a cell or row equate a one, so that I can tabulate the total of entries rather than numbering...is that possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help
I'm not sure I understand, but excel has a worksheet function that may help you:
=counta(a1:a10) will count the number of cells in A1:A10 that has anything in it--letters, numbers, formulas (even formulas that evaluate to ""). needing help wrote: I'm making a spreadsheet and I need to make my entry into a cell or row equate a one, so that I can tabulate the total of entries rather than numbering...is that possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
