How do I sum a row that I keep adding new data to on the left side?-CodePudding

Home > database > How do I sum a row that I keep adding new data to on the left side?

How do I sum a row that I keep adding new data to on the left side?

Time：11-30

I am trying to create a formula that totals the number of tardies for a student in column b when I insert a new column each day between column b and c (see example sheet

CodePudding user response：

use this:

=SUM(INDIRECT("C2:2"))

Page link：https//www.codepudding.com/database/626855.html

Prev:How to apply NBA win percentage formula to NBA data only with Google Sheets?

Next:How to find the highest N values in each group in Google Sheets

Tags：

google-sheets

Links：
CodePudding