EXCEL Problem

H

heafar

Joined
Nov 11, 2009
Messages
2
Reaction score
0
A B
RT 52.2%
RT 0.0%
DB 52.7%
RT 45.5%
RT 48.4%
EB 50.8%
RT 20.4%
EB 59.9%
RT 0.0%
EB 37.4%
EB 48.7%
RT 47.7%
RT 13.5%
DB 74.4%
EB 26.9%
EB 0.0%

Hi, from the above list I need to have an average of the ones listed as RT which are bigger than 0%. My plan was to use sumif to add the ones which are listed as RT, and then divide the total by the number of cells which belong to RT and are bigger than 0%.

Can someone indicate best way forward?

thanks
 
Last edited:
Excel Solution

Timeouts are bugging because I dont type fast enough....Try again...

Create new colum "X" at level with first entry in col "A" insert formula:
=IF(AND(A2="RT";B2>0);B2;0) now fill down series to last entry...Row 18 in your example
Where yo want to average the results from "RT" insert the following:
=((SUM(X2:X18))/(COUNTIF(X2:X18;">0)))
This will give the average of all "RT" values that are above "0"

Hope it works for you, Regards, Chuck D. ;)
 
Back
Top