How to sum a column by only pulling cells based on separate formula

Options

Hello - can someone help with the following formula(s)?

I want to include the cells included from this formula: =COUNTIFS([Card_StartDate]:[Card_StartDate], <=DATE(2021, 12, 31), LaneTitle:LaneTitle, NOT(CONTAINS("Parent", @cell)))

...And sum the totals from this column: Card_Size:Card_Size

The LaneTitle column is Text. The Card_StartDate column is Date. The Card_Size column is Text.

Thank you for any insights you can provide!

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Brooke Clem ,

    Try:

    =SUMIFS([Card_size]:[card_size], [Card_StartDate]:[Card_StartDate], <=DATE(2021, 12, 31), LaneTitle:LaneTitle, NOT(CONTAINS("Parent", @cell)))

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!