LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ladivapr
 
Posts: n/a
Default I need help has to do with counting


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting rows, then counting values. Michael via OfficeKB.com Excel Discussion (Misc queries) 7 August 4th 05 10:57 PM
Counting States basied on the time and date stamp TJ Excel Discussion (Misc queries) 1 July 7th 05 04:50 PM
Counting names in a column but counting duplicate names once TBoe Excel Discussion (Misc queries) 9 May 11th 05 11:24 PM
Counting... Patrick G Excel Worksheet Functions 3 February 23rd 05 10:05 PM
counting entries between two dates? Todd Excel Worksheet Functions 7 November 1st 04 11:07 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"