Thread: Average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S. Kissing S. Kissing is offline
external usenet poster
 
Posts: 11
Default Average

I have 13 sheets, Jan - Dec and a total sheet. I want to average cells in
the Jan - Dec sheets. If I add my formula to the sheets then my average
counts each sheet (12) I know I can add if statements to divide by only the
shhets with valuses 0 in the cells however it is becoming very very
long...is there a short cut I am missing? Thanks