Forum Discussion
Formula to pull from multiple columns in (IF/THEN) into field on another tab?
Am trying to get a formula to calculate the following from image below: Search column L for a value, AND search date range in column R, if both are true, then sum related values in Column W. I thou...
tauqeeracma THANK YOU! This was super helpful, I'm almost there. The formula is working for one cell, but not other date ranges despite altering accordingly for each month. I've also figured out how to pull from another sheet, but how do I get the right sums to show up - I've put a row of what it should be in the first sheet, pulling from data in second.
Formula now:
=SUMIFS(LineDetails!C:C,LineDetails!D:D,51103,LineDetails!B:B,">=6/1/18",LineDetails!B:B,"<=6/30/18")
I figured it out, for some reason when you copy paste the formula from D4, it changes - so as long as the columns remain, the formula will work! Thanks again 🙂 Saved my weekend
kmb126 You are welcome
