Use the sumif and countif functions: =sumif(saleperson_column,sales
person,amount_column) will total the rep's sales;
=countif(salesperson_column,sales person) will tell you how many invoices
that rep had.

"dj479794" wrote:

if i had revenue by invoice in a column and in a second column I had the
salesperson's name that sold the order. I want to summarize all orders by
salesperson. How would I write that formula. or will I have to use a pivot
table?