CODEWITHSUNDEEP
excel
matthew strange
matthew strange

Reputation: 5

How to copy complex formula across?

  1. I have the formula =SUM (indirect(C5:C"&ROW()-1))

How do I copy this across so if changes automatically to be "D5:D"

I was usIng basic SUM formula but need to add rows and data too much for tables.

Upvotes: 0

Views: 68

Answers (1)

Domenic
Domenic

Reputation: 8114

I would avoid using INDIRECT, since it's a volatile function. Try the following instead...

=SUM(C$5:INDEX(C:C,ROW()-1))

Upvotes: 1

Related Questions