Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria

Douglas Jerum

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!

Genevieve P.

Hi Douglas,

It sounds like you could use a straight-forward 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