SUMIFS with OR

neisdorfer

I feel ridiculous asking a question when I've seen several others on this same topic and I modeled my formula after them. I'm trying to sum an account total when the string matches either of two different strings and the account code matches a different criterion. I'm just getting an unparseable error so I'm sure it's a comma I'm not seeing. The columns are on a different sheet, hence the {}.

=SUMIFS({GLAmount},{GLAccount},=70410, {GLString},OR(@cell="V0158-620-9211",@cell="V0159-621-9211)).

I've also tried it without the @cell notation: =SUMIFS({GLAmount}, {GLAccount}, =70410,{GLString}, OR(="V0158-620-9211", ="V0159-621-9211))

What am I missing? Thank you!

Jeff Reisman

@neisdorfer You are close.

First, add some spaces in there, at least put one space after every comma.

Second, you're missing the end quotes after your second criteria in the OR statement. (This is probably the issue.)

If that's not it:

The GLAccount criteria you are looking for, 70410 - in your sheet is that a number value or a number stored as text? If it's a number stored as text, you'll need quotes around it in your formula and you can remove the = sign. (Easy way to tell generally is if Smartsheet puts the value on the left side of the cell it's stored as text, on the right side of the cell it's a number value.)

Jeff Reisman

@neisdorfer You are close.

First, add some spaces in there, at least put one space after every comma.

Second, you're missing the end quotes after your second criteria in the OR statement. (This is probably the issue.)

If that's not it:

The GLAccount criteria you are looking for, 70410 - in your sheet is that a number value or a number stored as text? If it's a number stored as text, you'll need quotes around it in your formula and you can remove the = sign. (Easy way to tell generally is if Smartsheet puts the value on the left side of the cell it's stored as text, on the right side of the cell it's a number value.)

neisdorfer

End quotes was the answer, thank you!!! I knew it was some piece of punctuation that I just wasn't seeing!