How do I sum a column dependent on another columns text value?
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? |
How do I sum a column dependent on another columns text value?
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? |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com