Average of cells

[Donald Michaud]

I am trying to get the average number of days required to
complete a project. The following chart is what the data
with the Average column what I need automated:

"Not to exceed" number of days for project
completion
Supervisor 1 2 3 4 5 6
Average
AH 12 11 6 0 4 0
1.8000
DA 18 5 0 1 1 0
1.8000
DR 14 11 3 0 0 0
1.8000
JK 0 0 0 0 0 0
0.0000
JM 19 16 10 4 5 2
1.8000
JR 4 13 0 0 0 1
2.8000
LM 2 0 0 0 0 0
1.0000
MJ 4 0 0 0 0 0
1.0000
MS 10 10 6 0 6 2
2.2000
PK 2 2 2 2 2 2
3.0000
SB 28 3 7 0 3 3
1.8000
SM 0 0 0 0 0 0
0.0000
WH 12 14 9 1 0 1
2.0000
WW 27 2 4 0 2 2
1.0000

I hope the chart makes sense. If you need me to send mor
detail, I can email it to you.
Thanks!!

Donald J. Michaud
616-647-6080

 

[Biff]

Hi Donald,

You can send me a copy of the file along with a detailed
desription of what you want to do.

biff_in_pitt at comcast dot net

Biff