LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Adding different text values

Hi:
I need to add all business lines - ie. A, B, C, D that are in a column.
A, B, C need to be added together
D needs to be added on it's own. This is what I ultimately need to know:
IF my lines of business are as follows-
a
a
b
c
c
d
d
c
a
Then my first total would be 7 for the a b c's
Then my second total would be 2 for the d's
I am using 2003 version.
Thank you in advance for your help.
Cindy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Adding multiple values in one column based on multiple values of the same value (text) in another column [email protected] Excel Discussion (Misc queries) 1 May 16th 07 06:02 PM
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
drop down list and adding numeric values to text Jill Excel Discussion (Misc queries) 2 October 6th 06 11:06 PM
adding values with text Ron Excel Worksheet Functions 2 July 13th 05 10:48 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"