Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A.
I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet summary I want to total up the commissions for entire sheet for each salesperson. I will have a sheet summary field for each salesperson, so there would be one formula for each salesperson.
Thanks in advance for any guidance!
Help Article Resources
Check out the Formula Handbook template!