A Sumif newbie needing help
Comments

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

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).
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!