Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SUMIFS Formula Help

Brandy S. PVD
edited 12/09/19 in Archived 2017 Posts

I want to calculate the Total Infill when the elevation is North, the floor is 2, and the L1 Infill Type - L10 Infill Type is GL-3.


=SUMIFS([Total Infill]:[Total Infill], Elevation:Elevation, "North", Floor:Floor, "2", [L1 Infill Type]:[L10 Infill Type], "GL-3")

This formula works perfectly if I only want to know the Total infill for the L1 Infill Type, but trying to search a range of Infill types is throwing back an Incorrect Argument.


=SUMIFS([Total Infill]:[Total Infill], Elevation:Elevation, "North", Floor:Floor, "2", [L1 Infill Type]:[L1 Infill Type], "GL-3", [L2 Infill Type]:[L2 Infill Type], "GL-3")

This formula returns "0" although it should reflect 0.67.


Any help is greatly appreciated.  Thanks in advance!




  • Shaine Greenwood

    Hi Brandy,

    One thing to check is to make sure that the cells are formatted to show decimal values—I get tripped up on this all the time. Select the cells and click the Increase Decimal button in the left toolbar to see if it shows anything but the integer.

    If the above doesn't work, are you able to publish your sheet temporarily? Or publish a copy of it with no data? I may be able to recreate and try to reproduce the behavior on my end and offer more advice. From looking at your formula and your screenshot, the formula LOOKS correct, but I can't see all of the columns that the formula is referencing.

  • Brandy S. PVD

    Hi Shaine,

    I thank you for your response, however we changed the logic path for our sheet and worked around this issue.

    Thank you,


This discussion has been closed.