F
Fin Fang Foom
Hi everyone,
Well I got this formula it was provided to me by Domenic and it work
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/showthread.php?t=53927&page=2
=SUMIF(A3:A39,E42,B3:B39)/COUNT(1/FREQUENCY(IF(A3:A39=E42,ROW(A3:A39)),IF(A3:A39<>E42,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
Well I got this formula it was provided to me by Domenic and it work
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/showthread.php?t=53927&page=2
=SUMIF(A3:A39,E42,B3:B39)/COUNT(1/FREQUENCY(IF(A3:A39=E42,ROW(A3:A39)),IF(A3:A39<>E42,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