I am trying to manipulate my SUMIFs Formula

Mathew Palter

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

Eric Law

@Mathew Palter

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%

Eric Law

@Mathew Palter

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%

Mathew Palter

https://community.smartsheet.com/discussion/comment/379282#Comment_379282

Yes that works thanks! I tried to make the simple complicated and caused myself a panic