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?