I need help has to do with counting

[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?

[Cutter]

You need to use the COUNT() function

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

[ladivapr]

Ahh thankyou that works!!

[Cutter]

You're welcome.