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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!