First create a reference table in an un-used column:

In A1 thru A.....

=IF(G5=0,"",G5)
=IF(K5=0,"",K5)

and so on down the column


Then use:
=AVERAGE(A1:A100)
and:
=MIN(A1:A100)

Making the zeros into blanks allows AVERAGE and MIN to ignore them.
--
Gary''s Student - gsnu200908


"Mike" wrote:

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