Formula Help

Allan Z

I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperson Any help appreciated of how the formula should look.

Jgorsich

If you don't have this bookmarked, I recommend it: Functions List | Smartsheet Learning Center

From that click on sumifs() and you get the following:

Syntax
SUMIFS(range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])
range— The cells to add, belonging to rows that meet all the criteria.
criterion_range1— The cells to evaluate by the criterion.
criterion1— The condition for cell values in the criterion range to match; for example: 15, "Hello World!", or >25.
criterion_range2, criterion2, ... —[optional] Additional ranges and criteria to evaluate.

So, in your case, if you are adding up everything in a single sheet:

=sumifs([Sales]:[Sales],[Name]:[Name],[Name]@row)

or, if your actual sales data is stored in some other sheet:

=sumifs({SalesData},{NamesFromDataSheet},[Name]@row)

Jgorsich

If you don't have this bookmarked, I recommend it: Functions List | Smartsheet Learning Center

From that click on sumifs() and you get the following:

Syntax
SUMIFS(range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])
range— The cells to add, belonging to rows that meet all the criteria.
criterion_range1— The cells to evaluate by the criterion.
criterion1— The condition for cell values in the criterion range to match; for example: 15, "Hello World!", or >25.
criterion_range2, criterion2, ... —[optional] Additional ranges and criteria to evaluate.

So, in your case, if you are adding up everything in a single sheet:

=sumifs([Sales]:[Sales],[Name]:[Name],[Name]@row)

or, if your actual sales data is stored in some other sheet:

=sumifs({SalesData},{NamesFromDataSheet},[Name]@row)

Allan Z

Many Thanks!! That worked and bookmarked the link for sure. appreciate the help