G
Guest
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!!!
"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!!!