SUMIFS Formula Help

Brandy S. PVD

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!

Brandy

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,

Brandy