C
Clay
I'm making a spreadsheet of 3 employees that will display what they have sold
to each different customer they talk to. In one column I have the
salesperson, identified as a number, and in the next column I have
Warranties. So if they sold a warranty to that person the price will be
typed in.
I have used the Countif function to count the number of people each sales
person has seen w/the formula, =COUNTIF(A7:A102,"1") .. where the sales
person is identified by 1.
I used the Sumif function to count the total warranty revenue by each sales
person w/the formula =SUMIF(A7:A102,"1",E7:E102).. where the sales person is
1 and column E contains the revenue.
But I also need to be able to count the total warranties sold by each sales
person. So if salesperson "1" has sold 8 warranties the formula will =8.
Any help is greatly appreciated! Thanks.
to each different customer they talk to. In one column I have the
salesperson, identified as a number, and in the next column I have
Warranties. So if they sold a warranty to that person the price will be
typed in.
I have used the Countif function to count the number of people each sales
person has seen w/the formula, =COUNTIF(A7:A102,"1") .. where the sales
person is identified by 1.
I used the Sumif function to count the total warranty revenue by each sales
person w/the formula =SUMIF(A7:A102,"1",E7:E102).. where the sales person is
1 and column E contains the revenue.
But I also need to be able to count the total warranties sold by each sales
person. So if salesperson "1" has sold 8 warranties the formula will =8.
Any help is greatly appreciated! Thanks.