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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!