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
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!