Sum if with a logical argument

Camyla Barbara Bezerra de Freitas

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)

Paul Newcome

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

Camyla Barbara Bezerra de Freitas

Data source.

Paul Newcome

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.

Camyla Barbara Bezerra de Freitas

Paul Newcome

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)

Camyla Barbara Bezerra de Freitas

Yeah, I think It solves my problem.

Thanks!

Paul Newcome

Great. Happy to help. 👍️