Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi,
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!
Answers

Hi Douglas,
It sounds like you could use a straightforward SUMIF formula for this!
A SUMIF works like this:
=SUMIF(Range, Range criterion, Sum Range)
So in your case:
=SUMIF([Salesperson Column]:[Salesperson Column], "Salesperson Name", [Commission Column]:[Commission Column])
If this doesn't work for you, it would be helpful to see a screen capture of your sheet with the column names & types, etc (but please block out any sensitive data).
Thanks!
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!