Posted to microsoft.public.excel.misc

Gingit

external usenet poster

Posts: 21

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF and LEFT and Named Ranges	DaveMoore	Excel Worksheet Functions	3	October 5th 06 12:10 PM
SUMIF and LEFT and Named Ranges	DaveMoore	Excel Worksheet Functions	1	October 5th 06 11:03 AM
SUMIF and LEFT and Named Ranges	DaveMoore	Excel Worksheet Functions	0	October 5th 06 09:39 AM
Vlookup to the left	comparini3000	Excel Worksheet Functions	4	June 23rd 06 09:22 PM
sumif function when left 4 texts are matching	Vikram Dhemare	Excel Discussion (Misc queries)	1	April 25th 06 08:27 AM

All times are GMT +1. The time now is 05:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us