About Us

Rick Rothstein \(MVP - VB\)

Yes, it does seem so.

Rick

"Don Guillett" wrote in message
...
Rick, It appears that the OP wants to do it the hard way.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
You can also do it with a SUMIF function call...

=SUMIF(A1:A10,"ABCDE*",B1:B10)

(Mat... note the asterisk after the 5 character string you want to sum
for)

Rick

"Don Guillett" wrote in message
...
No need to do that. Use SUMPRODUCT where col A is the co name and col B
is the numbers to be summed.

=sumproduct((left(a2:a22,5)="ABCDE")*B2:B22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mat" wrote in message
...
Dear mate,

I have 6000 client names and some are duplicates. I need to copy just
the
first 5 letters of each client from the cell and place in the next
cell. This
will help me to sum up all the ABCDE revenue as they are all same
client with
different names with the first 5 letters are common.
Hope I was able to explain my issue,

For example

ABCDE Ltd
ABCDE co.
ABCDE inc
ABCDE ltee

Regards
Mat

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to change small letters to capital letters	HOW TO CHANGE	Excel Discussion (Misc queries)	4	May 30th 07 01:12 AM
How do change a column of data in capitol letters to small letters	Barb P.	Excel Discussion (Misc queries)	6	November 15th 06 06:17 PM
change lower letters to upper letters	Winnie	Excel Discussion (Misc queries)	2	September 15th 06 04:58 AM
letters cut off in cell	Brian	Excel Worksheet Functions	1	August 19th 06 09:15 PM
Copy the first two or three letters of a cell to another one	Jerry	Excel Discussion (Misc queries)	4	February 22nd 06 06:29 AM

Menu

About Us