View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gingit Gingit is offline
external usenet poster
 
Posts: 21
Default Sumif/vlookup/left

I have the following spreadsheet:

Amount Work Order
25.65 AA-07020.0600
500.00 S-070200600.002
(904.81) AA-06020.0300.007
1000 08.5552.0000
585 07.526.589

I am trying to find using how to sum only the work orders that begin with an
AA and S.

Thanks,