Thread: excel help
View Single Post
Old Jun 28, 2005 | 06:23 PM
  #7  
Bl@ck's Avatar
Bl@ck
Sinner
 
Joined: May 2002
Posts: 6,599
Likes: 0
From: NoVA
Default
got it in one cell.....

=SUMIF($D$4:$D$84,"value",$K$4:$K$84)/COUNTIF($D$4:$D$84,"value")

again thanks
Reply
0