CODEWITHSUNDEEP
google-sheets
Amit Wagner
Amit Wagner

Reputation: 3264

Sum range with dynamic row on google sheet column

I'm trying to sum a trying column, I need the row in the range to be dynamic I have tried

=sum($B$9:CONCAT("B", ROW()))

and then drag it but I'm getting an error, I also tried with the address and it didn't work

Upvotes: 0

Views: 311

Answers (1)

doubleunary
doubleunary

Reputation: 19195

Spreadsheets have a simple way to express this sort of thing: absolute and relative references. Try this in cell C9:

=sum(B$9:B9)

Then drag down the formula cell to extend it to additional rows.

Upvotes: 2

Related Questions