I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so
=SUMIFS({Spend} * 0.25, {Phase}, "phase 1", {Status}, "IN PROGRESS"), However I get an Invalid Operation as I cannot multiply it. I am not sure if there is a way to use @cell to help me with this or if I am out of luck as the first range is where the data is summed from where as criteria can be manipulated. When I am not using the *0.25 there are no issues and the formula works
Best Answer
-
Would =SUMIFS({Spend}, {Phase}, "phase 1", {Status}, "IN PROGRESS")*0.25 not work? It just takes the sum then multiply it by 25%. You can do the same for 50%
Answers
-
Would =SUMIFS({Spend}, {Phase}, "phase 1", {Status}, "IN PROGRESS")*0.25 not work? It just takes the sum then multiply it by 25%. You can do the same for 50%
-
Yes that works thanks! I tried to make the simple complicated and caused myself a panic
Help Article Resources
Categories
Check out the Formula Handbook template!
