Formula range extends to include new rows/entries. Sheet Summary

Amy Martin

I'm using Sheet Summary to sum amounts on a sheet where new entries are occasionally added via forms. I want the new entries to be included in the range of cells summed, but that's not happening. Any tips?

Nick Brisson

Hi Amy

You'll want to grab the whole column as oppose to the range.

You do this by using the : for instance Sumif(Date:Date,>=Date(2020,1,1),Amount:Amount)

That will grab the whole group

Note, if there is a space in the Column Name that it needs to be referenced in box brackets.

For Example Sumif([date example]:[date example],>=Date(2020,1,1),Amount:Amount)

Nick Brisson

Hi Amy

You'll want to grab the whole column as oppose to the range.

You do this by using the : for instance Sumif(Date:Date,>=Date(2020,1,1),Amount:Amount)

That will grab the whole group

Note, if there is a space in the Column Name that it needs to be referenced in box brackets.

For Example Sumif([date example]:[date example],>=Date(2020,1,1),Amount:Amount)

Amy Martin

Awesome, thanks for your help!