find all cells in col A that start with a given 2 letters

[Wayne Duncan]

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"
Any suggestions?
This message was edited by Wayne Duncan on 2002-11-07 09:31

 

[Robert Mika]

Maybe something like that:

=IF(ISNUMBER(FIND("1/1",C5))=ISNUMBER(FIND("1/1",K5)),TRUE,FALSE)

 

[Aladin Akyurek]

Re: Compare letter in two cells

Thanks! I have another one for you and I promise I won't bother you for the read of the day
Cell C5 contains "1/1"
Cell K5 contains "Gi1/1"

I'm looking for a formula that will compare the "1/1" in each cell (ignoring "Gi" in cell K5) and give me a result "TRUE"<!-- / message -->

Try...

=OR(ISNUMBER(SEARCH(C5,K5)),ISNUMBER(SEARCH(K5,C5)))