fixthis
New Member
Hi,
Looking for shorter formula to sum the highest values for each part description type.
This formula does work:
Running Excel 2010 on Windows 7.
Looking for shorter formula to sum the highest values for each part description type.
This formula does work:
Code:
=SUM(MAX(IF(--ISNUMBER(SEARCH("CM2000",$C$3:$C$14)),$F$3:$F$14)),MAX(IF(--ISNUMBER(SEARCH("CM4000",$C$3:$C$14)),$F$3:$F$14)),MAX(IF(--ISNUMBER(SEARCH("CM5077",$C$3:$C$14)),$F$3:$F$14)))
Running Excel 2010 on Windows 7.