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

Find more posts tagged with

Formulas

Comments

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).

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…