PPRuNe Forums - View Single Post - Excel: Average formula question
View Single Post
Old 15th Nov 2007, 15:56
  #6 (permalink)  
Icarus
 
Join Date: Jun 2001
Location: Intentionally Left Blank
Posts: 382
Likes: 0
Received 0 Likes on 0 Posts
Isn't this just a case of using the COUNTIF and SUMIF formulas?

Use COUNTIF to count the number of cells with a value greater than zero; use the SUMIF to SUM the cells if they are greater than zero and then divide the two? (=SUMIF(range,criteria)/COUNTIF(range,criteria)
Icarus is offline