Don{ald} O. Woodall wrote:

>In , on 12/13/2004 
>   at 09:10 PM, "Mike O'Connor"  said:
>
>Mike
>  
>
>>Hi Don,
>>Now that you've found out the difficult way to do it - here's the simple 
>>way:
>>1). select the cell where you want to enter the computed total e.g. F32
>>2). in the data/formula entry area type "=sum("  [unquoted] 3).
>>   click in cell F2 and DRAG down to cell F31 [this then enters
>>   "F2:F31" into the formula]
>>4). type closing ")" then either select the
"YES-tick" button
>>   or hit [ENTER]
>>    
>>
>     "YES-tick" button ?
>
The button between "$$" and "X" immediately left of the
data/formula 
entry-box!

>  Ah, never mind.  I'll figure it out in a couple
>of days when I do my next spreadsheet.
>  
>
>>   Doing the DRAG-select allows for non-contiguous entries -
>>   it will in this case give the correct total if the only cells
>>   populated in the F-column were e.g.
>>   F2,F3,F5,F6,F18,F23,F24,F25,F28,F31. 5).
>>   In e.g. cell F33, enter "=(F32/count(" [unquoted]
>>6). drag-select the range as above and enter "))"
>>   [unquoted] and hit [ENTER]
>>    
>>
>>You will now have a total in F32 and the average in F33
>>    
>>
>>"count" ignores empty/non-numeric entries!
>>    
>>
>     That I did not know, is not intuitive to me.  I started at F2 because
>F1 is the column header.
>
>>HTH
>>    
>>
>     Thanks Mike
>  
>

Hi Don,

You're welcome!

I wrote a spreadsheet in Fortran in the 1970-1971 era, back before 
VisiCalc came out , and used to be very inventive with Execuplan [on 
CP/M II circa 1980 on a Z-80 S100 machine]/Multiplan/123/Excel/Quattro 
Pro etc on x86, so was very familiar with the included functions on 
them, especially as I had already implemented most of them as components 
before they ever got incorporated into the applications themselves.

WRT IBMWorks Help - after peeling off a spreadsheet template - goto 
HELP|Procedures|Search "functions"|Function List to get a full listing 
of functions available.

In my example I could have used Average|Avg in lieu of using 
average=total/count (of items), which lets you reuse the count value 
elsewhere.

It's good to learn something new every day!

P.S. to just sum a [partial] column select the range of cells, then 
click the Sigma ICON on the toolbar [between right-justified and Graph].

-- 
Regards,
Mike

Failed the exam for
--------------------
MCSE - Minesweeper Consultant and Solitaire Expert
--------------------
[ISP blocks *.exe, *.cmd, *.com, *.bat, *.reg attachments]
[Please use zipped versions of above]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/E8folB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

 To visit your group on the web, go to:
    http://groups.yahoo.com/group/os2user/

 To unsubscribe from this group, send an email to:
    os2user-unsubscribe{at}yahoogroups.com

 Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 




---