Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default summing by text in another column

Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different
column, how do I add those as well as 20 other people's commissions by their
names?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default summing by text in another column

hi
names in column A
commissions in column B
=sumif(A1:A100,"Bubba",B2:B100)
adjust ranges to suit.

Regards
FSt1

"schmas" wrote:

Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different
column, how do I add those as well as 20 other people's commissions by their
names?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default summing by text in another column

Hi
Something like this =SUMIF(A1:A207,"Bubba",B1:B20)
HTH
John
"schmas" wrote in message
...
Can I sum numbers in one column based on the name in another column? So
if
Bubba is listed 5 times with 5 different numbers (commissions) in a
different
column, how do I add those as well as 20 other people's commissions by
their
names?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default summing by text in another column

Simplest way is to use sumif command. suppose names are in column A and
numbers(commissions) are in column B. The syntax for sumif is as follows:
sumif(range,criteria,sum_range)
For range you have to address column A (names)
For criteria you have to specify a name you are trying to sum, like "Bubba "
For sum_range you have to specify column B (numbers you want to sum up)
For criteria, you can either specify the name by typing it enclosing inside
"" or you can type the address of cell which contains the name.

Excel 2003 and higher ver have a wizard which guides you through steps to
perform conditional su.m it is under Tools/Conditional sum.

Hope this helps

"schmas" wrote:

Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different
column, how do I add those as well as 20 other people's commissions by their
names?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default summing by text in another column

What if I have a bunch of different names in column A and I want a sum for
each name? Is there a fast and easy way or will I have to do the below
formula for each name?

"FSt1" wrote:

hi
names in column A
commissions in column B
=sumif(A1:A100,"Bubba",B2:B100)
adjust ranges to suit.

Regards
FSt1

"schmas" wrote:

Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different
column, how do I add those as well as 20 other people's commissions by their
names?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default summing by text in another column

hi
yes, you would need a sumif for each name should you want a seperate total
for each name.
you might create a small table with the names with totals for each name. you
could then sum the sumif's for a grand total and cross reference the sumif
totals to the commissions column total.
Regards
FSt1

"schmas" wrote:

What if I have a bunch of different names in column A and I want a sum for
each name? Is there a fast and easy way or will I have to do the below
formula for each name?

"FSt1" wrote:

hi
names in column A
commissions in column B
=sumif(A1:A100,"Bubba",B2:B100)
adjust ranges to suit.

Regards
FSt1

"schmas" wrote:

Can I sum numbers in one column based on the name in another column? So if
Bubba is listed 5 times with 5 different numbers (commissions) in a different
column, how do I add those as well as 20 other people's commissions by their
names?

Reply
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
Summing a column based on the length of text in a cell in anothercolumn [email protected] Excel Worksheet Functions 13 November 26th 08 06:42 PM
need help summing text in column Laura Larson Excel Worksheet Functions 3 June 4th 08 02:23 AM
summing column c based an column a criteria ndforty Excel Worksheet Functions 2 May 3rd 07 07:57 PM
Summing a Column instead of a Column range SharonP. Excel Discussion (Misc queries) 1 February 16th 06 08:28 PM
Summing one column based on date in another column excel guru i'm not New Users to Excel 7 December 30th 05 09:39 PM


All times are GMT +1. The time now is 02:41 AM.

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"