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
