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
