Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |