Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Formulas

i am looking to get an average of a group of cells but I do not want the cell
with a 0 in to be included but the cells numbers will change when I reuse the
sheet. for example a2 will be a 253 cell a3 will be 0 cell a4 will be 432 but
the next day these cell numbers will changeA1 and A@ will have # and A4 will
not and I dont want to change the formuka every day.