Don{ald} O. Woodall wrote:

>Hello Blue Streakers
>
>     There ain't no help in/with IBM Works!  Who wrote what they are
>calling "Help" must be Phd's who can't find the bathroom.
>
>     I have a column of dollar amounts:  F2 to F31
>
>     I want to get a total.
>
>     I also want to get an average value.
>
>     The main stumbling block seems to be:  How the hell do
>you tell it what range of cells to perform the math on? ????
>
>     Thanks
>

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]

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!

HTH

-- 
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 --------------------~--> 
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
 




---