I think you want SUMPRODUCT.

=SUMPRODUCT(--(A7:A102="1"),--(B7:B102="Yes"))

In the above formula, it assumes that a warranty sold is indicated by "Yes"
in column B. You can adjust this to meet the actual criteria.

Does that do what you want?
Regards,
Paul

--

"Clay" wrote in message
...
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.