Anyone else want to get this formula to work as a wildcard?
=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))))
--
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