D
DMB
I am trying to find a formula that can sum the value of a cell if it contains
a certain value.
For example:
I have 100 sales that were made and 10 sales people. Each sales person has
different sales $$ volume that they done. So I want to find the TOTAL sales
volume for each sales person.
Their sales volume is in one column and their name is in another. I need a
formula that will give me the toal volume for example sum C2 if B2 = Bob.
Thanks.
a certain value.
For example:
I have 100 sales that were made and 10 sales people. Each sales person has
different sales $$ volume that they done. So I want to find the TOTAL sales
volume for each sales person.
Their sales volume is in one column and their name is in another. I need a
formula that will give me the toal volume for example sum C2 if B2 = Bob.
Thanks.