How do I sum a column dependent on another columns text value?

D

dj479794

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?
 
B

bpeltzer

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.
 
Top