Help with creating formula
Hello - I need some help with a formula.... Hopefully someone from this community can provide some guidance.
I have the following sheet with multiple columns. I am trying to sum up the total "Approved Change Order Amount" by "Category".
For instance, rows #1 and # 6 have the same category (Regulatory Submissions). Based on the "Approved Change Order Amount" column, the sum for both rows should be $23,000.
I plan to add this formula in the Summary Sheet (instead of adding another column with this formula).
Thank you!
Best Answer
-
If you only want to add those if the Status is Approved, you'd use this formula:
=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")
Answers
-
If you only want to add those if the Status is Approved, you'd use this formula:
=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")
-
Thank you!!! This formula worked, and you saved me a lot of time :)
-
@Mike TV Do you happen to know how to cross reference a sheet by using this formula?
Essentially, I plan to create another sheet with two columns (category name and formula), as seen below:
Then, I want to extract the data from another sheet titled "Change Order Log". The original formula works well if I use it in the Change Order Log sheet (since this is where I have my data). But how do I transfer the final result of this formula to this new sheet?
Original formula: =SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS("Regulatory Submissions", @cell), Status:Status, "Approved")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!