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
Check out the Formula Handbook template!