min,average>0 if 52 cells read zero

[Mike]

I have 52 cells w265 that all read zero until data is entered this means one
cell in each worksheet example Week 1 w265, week 2 w265, week 3 w265 to week
52 w265. on a seperate work sheet im trying to caculate min & average for
efficiency but when data is entered for min i get zero because of other cells
that read zero or the average is incorrect too low I have to have zero,s in
place on the 52 worksheets but i don,t want io include them when calculating
min or average on seperate work sheet can some please help

 

[Bernie Deitrick]

Mike,

The easiest thing to do is to completely empty all your data cells, or have
formulas that fill the averaged cells with "" until you enter data, and
Excel will ignore them for numeric calculations.

HTH,
Bernie
MS Excel MVP

 

[Gary''s Student]

=MIN(IF(A1:A100<>0,A1:A100,""))

This is an array formula that must be entered with
CNTRL-SHFT-ENTER
rather than just the ENTER key.


Similar for average.