Welcome!

Summary table - parsing a table of variable qty of records

Hi,

I have a sheet which is an action tracker

Actions are adding to the sheet as added rows.

I am willing to make some stats andI have to parse the full sheet from top to bottom using countifs functions and alike.

PB: my sheet is constantly increasing in length, hence my countifs formula does not parse the full sheet unless I manually update it.

Is there a way to have that done automatically?

Thanks and warm regards

Bruno

Find more posts tagged with

Comments

J. Craig Williams

Bruno,

If your formula is not in the same row as the criteria or count, you can reference the entire column

=COUNTIF([My Column]:[My Column],"Red")

will check the whole column, including added rows, for the text or symbol "Red"

Hope that helps.

Craig

thadr

Hi Bruno,

New to the community but not new to smartsheet or spreadsheet functions. I haven't had to gather stats like your scenario below but I have done something similar in my past life with spreadsheets.

Have you tried calculating your stats at the top of the sheet and take into column into consideration for your formulas rather than just your rows? If you do a countif for your column, it will always come back with the correct number even when additional rows are being added.

I hope this helps.

Best

Bruno

Thank you,

problem solved :-)

Happy