Help with creating formula

Vane

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!

Mike TV

@Vane

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")

Mike TV

@Vane

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")

Vane

@Mike TV

Thank you!!! This formula worked, and you saved me a lot of time :)

Vane

@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")