SUMIFS With Multiple Criteria

stratman

Good day Smartsheet team,

I'm a hardcore Excel user attempting to migrate my skills over to Smartsheet and I'm getting lost in the translation.

Attempting to set up a formula to pull specific data into a sheet using SUMIFS. Here's my formula:

=SUMIFS({GLData Range 1}, {GLData Range 3}, MONTH(@cell ) = 4, {GLData Range 4}, "RES602497", OR({GLData Range 4}, "RES602782", {GLData Range 5}, "Major Equip", OR({GLData Range 5}, "Minor Equip")))

English: Sum the data in GLData Range 1 if the date in GLData Range 3 is equal to month =4, the data in GLData Range 4 is equal to "RES602497" or "RES602782", and the data in GLData Range 5 is equal to "Major Equip" or "Minor Equip".

Result: #INVALID DATA TYPE

Smartsheet: ?

Thanks in advance for the review and consideration.

Paul Newcome

When using an OR function in Smartsheet like this, you want to list the range once and then use the OR to list out the different criteria sets.

=SUMIFS({Range To Sum}, {Criteria Range}, OR(@cell = "This", @cell = "That"))

Paul Newcome

When using an OR function in Smartsheet like this, you want to list the range once and then use the OR to list out the different criteria sets.

=SUMIFS({Range To Sum}, {Criteria Range}, OR(@cell = "This", @cell = "That"))