SUM IF issues

fiorellag

Hi friends!

I need help with my SUM formula -

=SUMIF({Opens RMT Range 1}, "Yes", {Opens RMT Range 2}, "Requested", {Opens RMT Range 3})

What am I doing wrong? I get #INCORRECTARGUMENT

Ty!

Jgorsich

You want to use sumifs rather than sumif, doing that will allow you to have multiple criteria:

SUMIFS Function | Smartsheet Learning Center

Jgorsich

You want to use sumifs rather than sumif, doing that will allow you to have multiple criteria:

SUMIFS Function | Smartsheet Learning Center

fiorellag

YAY! Thank you! @Jgorsich