Ditto that, Michelle. A pivot table is awkward the first hour or so, after
that you cant imagine how you managed without.
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
I'd give a money back guarantee if this wasn't for free already.

HTH. Best wishes Harald

"Michelle Tucker" skrev i melding
...
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