Need Help

N

needing 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?
 
D

Dave Peterson

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 "").
 
Top