# Sum if with a logical argument

Options

Hi!

I'm trying to create a formula that Sums with two criteria, but one of those can change because references to the number of the product we are tracking. It's possible some how to make this info change automaticly so I don't have to change the formula manually after every product change?

=SUMIFS({Apontamento 77.4 P5 Tip Range 4}, {Apontamento 77.4 P5 Tip Range 5}, "1", {Apontamento 77.4 P5 Tip Range 6}, "Upwind")

(Yellow = product info)

## Answers

• ✭✭✭✭✭✭
Options

Is your screenshot of the sheet your formula is on or the sheet the source data is on?

• Options

Data source.

• ✭✭✭✭✭✭
Options

Ok. Are you able to provide a screenshot of the sheet the formula is on?

If you have a cell that you can enter the number in, then you can use a cell reference in the formula.

• Options
• ✭✭✭✭✭✭
Options

Try...

=SUMIFS({Apontamento 77.4 P5 Tip Range 4}, {Apontamento 77.4 P5 Tip Range 5}, Pa@row, {Apontamento 77.4 P5 Tip Range 6}, Casca@row)

• Options

Yeah, I think It solves my problem.

Thanks!

• ✭✭✭✭✭✭
Options

Great. Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!