sum if
hi
i am making a cross reference sheet. in one cell i want a sum of "quote for client" column if "approved" column says "yes"
Answers
-
=SUMIFS({Reference 'Quote for Client' Column},{Reference 'Approved' Cloumn},"YES")
-
thanks
i already solved myself
now i am trying to sumifs from multiple sheets
i wrote:
=SUMIFS({2022 - Material 01-JAN Range 5}, {2022 - Material 01-JAN Range 4}, 1) + SUMIFS({2022 - Material 01-JAN Range 1}, {2022 - Material 01-JAN Range 2}, 1)
didn't work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!