=SUMPRODUCT((LEFT(A2:A100,2)="PM")+0,B2:B100)On 2002-11-07 09:30, Wayne Duncan wrote:
In col A I have various text codes in no particular order: i.e.cell A2 is PM-A01, cell A3 is BTC05, cell A4 is PM-B00, etc. The first two positions are always alphabetic. I want to sum all the numbers in column B whose adjacent column A text starts with "PM".
I tried =IF(match("PM*",A2:A100,0),b2,"") but just get "NA"
[ This Message was edited by: Wayne Duncan on 2002-11-07 09:31 ]
& using SUMIF is much cheaper...
[ This Message was edited by: Aladin Akyurek on 2002-11-07 09:40 ]