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!

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.