View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heater heater is offline
external usenet poster
 
Posts: 17
Default Sumproduct...Average

I have 12 different tabs. I want to average a number on each tab only if the
number is greater than zero. So, on tab 1 cell b6=140, tab 2 b6=245, tab 3
b6=0 and so on with b6 on each tab having a number greater than 0 sometimes.