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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!