Sum if with a logical argument
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
-
Is your screenshot of the sheet your formula is on or the sheet the source data is on?
-
Data source.
-
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.
-
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)
-
Yeah, I think It solves my problem.
Thanks!
-
Help Article Resources
Categories
Check out the Formula Handbook template!