Automate Row reference in Sheet Summary Field

Bennett R.

Hello,

I have a sheet that regularly updates with new rows. I use the "Sheet Summary" tool to summarize columns of data that are then shown in reports. Whenever a new row is created in this sheet (by a form), the sheet summary field does not update to include that row in the summary.

Is it possible to have the sheet summary formula include ALL rows, or update the row reference as new rows are created?

SJ Sellers

Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

SJ Sellers

Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

Bennett R.

Hi SJ,

I am using quite a few, but here is a countifs formula that should show what what i'm doing for most.

I use similar formulae for sumifs for the same data sets.

=COUNTIFS([Sub-SBU]1:[Sub-SBU]36, "Hardlines", [Project Type]1:[Project Type]36, "Productivity")

I'll try =COUNTIFS([Sub-SBU]:[Sub-SBU], "Hardlines", [Project Type]:[Project Type], "Productivity")

and see how the goes.