View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default min,average0 if 52 cells read zero

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