Jan 11 2023 11:02 AM
Trying to find a solution to Sum(x1:xa) where a is a variable number 1-12
Jan 11 2023 11:34 AM
Jan 12 2023 04:39 AM
Jan 12 2023 05:15 AM
An alternative:
Let's say you enter a value in cell D1
=SUM(INDIRECT("A1:A"&D1))
(I don't think it's possible to do what you want without nesting a function within SUM)
Jan 12 2023 12:10 PM