Thread: excel help
View Single Post
Old Jun 28, 2005 | 05:53 PM
  #4  
flipped cracka's Avatar
flipped cracka
BOOM goes the dynamite!
 
Joined: Mar 2003
Posts: 27,571
Likes: 1
From: in a van down by the rive
Default

i can do it with 3 cells for each level. i'm sure there's a better way to do it though.

i used sumif and countif. use sumif to add up the total time depending on the level, and then countif to figure out how many of each level there is. then divide the sumif cell by the countif cell to get the average.
Reply