Thanks you Stephen and Tom. This worked perfectly, the line above the
average was the total for the column and I had used the "autosum" icon
which when you left one of the lines blank it gave you the #VALUE
warning, once I change it from the autosum to a formula then the
entire spreadsheet now works.
I love this group, so many willing to give.
Many thanks,
John
On Dec 5, 2008, at 12:52 AM, Stephen Ellis wrote:
John,
The function AVERAGE will average all of the nonblank cells to which
it refers. For example, put the number 20 in cells e5, e6, e7 ,e8,
and e9. Then in cell e11 type "=AVERAGE(E5:E9)".
The number 20 will be returned in cell e11. Blank cell e7. The
number 20 still appears in cell e11. If you place the value 0 in
e7, the value in e11 will be 16, since 0 is inlcluded in the
average. Hope this helps.
Steve
[EMAIL PROTECTED]
home: (502) 893-2446
cell: (502) 552-7268
"Against stupidity the very gods
Themselves contend in vain"
-- Friedrich Schiller
On Thu, Dec 4, 2008 at 7:46 PM, Profile <[EMAIL PROTECTED]> wrote:
I need help from an Excel guru. I don't know how to create the
formulas for what I am needing for a friend. They have to report
to their conference the attendance for the month in their Church,
for Sunday school, AM Church and PM Church.
I have designed the form, created the necessary fields with the
totals and all works fine but I don't know how to write the formula
for the averages if it is a 4 Sunday month or a 5 Sunday month. If
every month was one or the other I would be done but how do you
write a formula that will do the "count" of the columns that only
have numbers and not a zero, if a zero then it will divide by the 4
instead of the 5?
Not sure I am even asking the question correctly. I could show them
how to change the 5 to a 4 in the header but it would be easier for
them if the cell could do the work.
If anyone knows I sure would appreciate an example of how to write
this into the cell.
Many thanks,
John
_______________________________________________
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge Lane.
Posting address: [email protected]
Information: http://www.math.louisville.edu/mailman/listinfo/macgroup
_______________________________________________
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge Lane.
Posting address: [email protected]
Information: http://www.math.louisville.edu/mailman/listinfo/macgroup
_______________________________________________
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge Lane.
Posting address: [email protected]
Information: http://www.math.louisville.edu/mailman/listinfo/macgroup
