SUM & SUMIFS

I have columns named:
- Item Description (That contains within a text (Z123)
- Quantity
- Received (Check Box)
Not sure if you can use SUM and SUMIFS in same formula
Looking for a result of ~~ Out of a total of (NUMBER) you have received(NUMBER).
Thanks!
Answers
-
@DanielGD Try this
= "Out of a total of "+ SUMIF(Description:Description, =Description@row, Quantity:Quantity) + " you have received " + SUMIFS(Quantity:Quantity, Description:Description, =Description@row, Received:Received, =1)
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
This would give you % received
=(SUMIFS(Quantity:Quantity, Description:Description, =Description@row, Received:Received, =1)) / SUMIF(Description:Description, =Description@row, Quantity:Quantity)
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!