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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

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

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @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
    Vane ✭✭✭

    @Mike TV

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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!