You could also create a Pivot Table. Perfect for this type of report

DataPivot Table... & follow the wizard

"Michelle Tucker" wrote:

I always seem to have this problem, and any solutions I have I don't truly
understand!
I have a list of products sold in one column, and in the next, the name of
the salesperson who sold it.
What I want to do is count up the amount of particular products sold by each
person.
I understand countif and sumif, but it seems to be done with a combintation
of INDEX and MATCH, which I don't get.
What is the easiest way to do this as it is something I always seem to need
to do, but then chicken out!
--
Michelle Tucker