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!