I need help has to do with counting

L

ladivapr

Okay guys I have an excel worksheet and this is what i need to do.

I'm entering numbers and at the end I want a sum. But the thing is that
it is not a sum of all the numbers within the cells but a sum of the
number of cells that have a number on it in a row. Like if the row
looks like [Blank cell]- 5 - 1 - [Blank cell] I want at the end of the
row a sum that is equal to 2 because only 2 cells have numbers on it.
Does it makes sense? Can I do this in excel?
 
C

Cutter

You need to use the COUNT() function

COUNT(A1:A10) will tell you how many cells within that range have
numbers in them
 
Top