I am trying to build a Sum If with a cross sheet reference but can't think of the formula.
I am trying to build a Sum If with a cross sheet reference to where IF a plant is __x__, and IF the end date was within this current month (not last 30 days, current month), then it will add the values in the actual value column for that plant on a metric sheet. How would I set this up/ what would that formula look like?
Best Answer
-
Actually just figured it out on my own, posting for anyone who may need it. This is what worked: =SUMIFS({Actual Value}, {Plant}, "Ajax", {Margin Enhancement Intake Sheet Range 2}, IF(ISDATE(@cell ), MONTH(@cell )) = MONTH(TODAY()))@cell
Answers
-
This is the formula I tried: "=SUMIFS({Actual Value}, {Plant}, "Ajax", {Margin Enhancement Intake Sheet Range 2}, MONTH(TODAY))"
-
Actually just figured it out on my own, posting for anyone who may need it. This is what worked: =SUMIFS({Actual Value}, {Plant}, "Ajax", {Margin Enhancement Intake Sheet Range 2}, IF(ISDATE(@cell ), MONTH(@cell )) = MONTH(TODAY()))@cell
Help Article Resources
Categories
Check out the Formula Handbook template!