Mike

For the average, it might be useful to have a range of "helper" cells to aid
the calculation. This wouldn't necessarily replace the existing cells.

For example, if you used the range A5 to BZ5, the (average) formula would
be:

=IF(ISERROR(SUM(A5:BZ5)/COUNTIF(A5:BZ5,"<")),0,SUM(A5:BZ5)/COUNTIF(A5:BZ5,"0"))

Regards

Trevor

"Mike" wrote in message
...
I am trying to get min & average 0n cells
G5,K5,O5,S5W5,AA5,AE5,AI5,AM5,AQ5,AU5,AY5,BC5,BG5, BK5,BO5,BS5,BW5,CA5,CE5,CI5,CM5,CQ5,CU5,CY5,DC5,DG 5,DK5,DO5,DS5,DW5,EA5,EE5,EI5,EM5,EQ5,EU5,EY5,FC5, FG5,FK5,FO5,FS5,FW5,GA5,GE5,GI5,GM5,GQ5,GU5,GY5,HC 5,
all these cells have zero,s until data is entered on seperate work sheets
these cells im trying to min or average = 52 weeks so i want the min &
average to be calculated as each weeks data is entered can anyone please
help
I TRIED ALOT OF DIFFERENT FORMULAS BUT I CAN,T GET IT TO WORK