Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JoJoBinkus
 
Posts: n/a
Default Conditional Adding/Totaling

I have 2 columns, one is "cost" which is in currency form, and the other is
"salesperson".....(there are only 2 salespeople)

At the bottom of my sheet I have 3 squares, one for saleperson1,
saleperson2, and grand total....

I know how to show the grand total by totaling the whole column....

But how do I total the costs of 1 particular salesperson? In psuedo-code like:

If COLUMN B, ROW1 = "Tim" then Add COLUMN A, ROW1 to the total square at the
bottom for salesperson1...

Does anyone know how to do this?

Thanks!!!
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Use SUMIF. For an example, see:

http://www.techonthenet.com/excel/formulas/sumif.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
I have 2 columns, one is "cost" which is in currency

form, and the other is
"salesperson".....(there are only 2 salespeople)

At the bottom of my sheet I have 3 squares, one for

saleperson1,
saleperson2, and grand total....

I know how to show the grand total by totaling the whole

column....

But how do I total the costs of 1 particular

salesperson? In psuedo-code like:

If COLUMN B, ROW1 = "Tim" then Add COLUMN A, ROW1 to the

total square at the
bottom for salesperson1...

Does anyone know how to do this?

Thanks!!!
.

  #3   Report Post  
 
Posts: n/a
Default

hi
assuming that costs is column a2:A100 and salepersons is
column b2:b100:

=sumif(b2:b100,"salesperson1",A2:A100)

-----Original Message-----
I have 2 columns, one is "cost" which is in currency

form, and the other is
"salesperson".....(there are only 2 salespeople)

At the bottom of my sheet I have 3 squares, one for

saleperson1,
saleperson2, and grand total....

I know how to show the grand total by totaling the whole

column....

But how do I total the costs of 1 particular salesperson?

In psuedo-code like:

If COLUMN B, ROW1 = "Tim" then Add COLUMN A, ROW1 to the

total square at the
bottom for salesperson1...

Does anyone know how to do this?

Thanks!!!
.

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
Formula Dependant Conditional Formatting LDanix Excel Discussion (Misc queries) 1 January 13th 05 07:50 PM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 02:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 07:03 PM


All times are GMT +1. The time now is 06:36 AM.

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

About Us

"It's about Microsoft Excel"