Hi there.
I have a large spread sheet with 566 rows. As data comes in the future I have to add rows.
I have a total sheet that totals products, hazard patterns, deaths, injuries etc. How can I make my total sheet continue to count
as I add in new rows? For instance new data was added so I now have 567 rows. All of my countif and sum totals have to be updated to 567 to count that row. Is there a way to create an infinite formula so I would not have to update all the totals? Somehow make them update automatically?

Thanks so much

Kaiser