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<>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 is:
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?
Bookmarks