View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clay Clay is offline
external usenet poster
 
Posts: 29
Default Help with countif and sumif functions

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.