Hello All-
I apologize if this has been asked before, but I've been unable to locate an understandable answer. I'm attempting to use the SUM function on an indirect range so that I can insert columns with current dates, but I need to have the columns be dynamic for alphabetization purposes in our vertical. I've tried using $, but I have been unsuccessful thus far. Here's what I have been using:
=SUM(INDIRECT("B2"):INDIRECT("F2"))
This formula works to calculate the data I need, but I need to be able to pull it down to fill any cells that are not filled as rows get added. The formula also needs to be able to adapt to when I am adding rows above it. Any ideas? Any help would be greatly appreciated.