A Sumif newbie needing help

Bobby Thomas

Trying to write my first sumif equation and having a little trouble.

Column Headers: Fabricator and Line Total

If Fabricator: American* then sum Line total

Here's my "formula"

=SUMIF(Fabricator2:Fabricator40, =American*, [Line Total2:Line Total40])

Any help with be appreciated

Dartwohl

Try this:

=SUMIF([Fabricator]:[Fabricator] , "American," [Line Total]:[Line Total])

Robert S.

Hello Bobby,

 

Thanks for the question. Dartwohl's formula should work for this, however I wanted to explain a little further. When referencing cells or ranges of cells, each column name needs to be surrounded with square brackets [ ] if the column name contains spaces, numbers, or special characters. If the column name doesn't have any of these, the square brackets can either be there or not. In this formula for instance, the "Fabricator" doesn't need them but the "Line Total" does because of the space. 

 

The other thing to mention is how the criteria is written. In this case, you're looking for the text value "American*", which needs to be surrounded in quotations " " since it's text. If you were looking for a number value instead of a text value, the quotations wouldn't be needed.

 

To learn more about these as well as everything else around creating formulas in Smartsheet, check out our help center article here (https://help.smartsheet.com/articles/2476171).