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

Brooke Clem

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!

Mark Cronk

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

Mark Cronk

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

Brooke Clem

by george you"ve got it! thank you!

Mark Cronk

Happy yo help. Thank you for contributing to the Communuty.

Mark