Hi everyone,
Well I got this formula it was provided to me by Domenic and it works
great. But I would like to have a wildcard in place in the formula.
I also posted on this forum.
http://www.ozgrid.com/forum/showthre...t=53927&page=2
=SUMIF(A3:A39,E42,B3:B39)/COUNT(1/FREQUENCY(IF(A3:A39=E42,ROW(A3:A39)),IF(A3:A39<E4 2,ROW(A3:A39))))
I tried to modified to this but no luck.
=SUMIF(A3:A39,"COPE &
DRAG*",B3:B39)/COUNT(1/FREQUENCY(IF((LEFT(A3:A39,11)="COPE &
DRAG"),ROW(A3:A39)),IF((LEFT(A3:A39,11)="COPE & DRAG"),ROW(A3:A39))))
Example, My data is structure to this
A B
COPE & DRAG ( #3 ) 0.31
COPE & DRAG ( #3 ) 0.06
COPE & DRAG ( #2 ) 1
COPE & DRAG ( #2 ) 0
COPE & DRAG ( #3 ) 0.31
COPE & DRAG ( #3 ) 0.06
COPE & DRAG ( #2 ) 1
COPE & DRAG ( #2 ) 0
The Total shoud be 1.37
Any Ideas?
--
Fin Fang Foom
------------------------------------------------------------------------
Fin Fang Foom's Profile:
http://www.excelforum.com/member.php...o&userid=36516
View this thread:
http://www.excelforum.com/showthread...hreadid=562724