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?


--
ladivapr
------------------------------------------------------------------------
ladivapr's Profile: http://www.excelforum.com/member.php...o&userid=23643
View this thread: http://www.excelforum.com/showthread...hreadid=396312

You need to use the COUNT() function

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=396312

Ahh thankyou that works!! :)


--
ladivapr
------------------------------------------------------------------------
ladivapr's Profile: http://www.excelforum.com/member.php...o&userid=23643
View this thread: http://www.excelforum.com/showthread...hreadid=396312

You're welcome.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=396312