Forum Discussion
Multi-line range used for summing specific column
I have a file in which I'm going to be constantly expanding the vertical length of a 36 month span of months. Specifically, I'll have various sections (all very similar, but not identical, in struct...
I would not try to combine data and a formated report in one sheet. Why not make sure you have columns next to the data for whatever categories or other groupings you need for subtotalling and then use a pivot table to create the report and its sub-totals.
It's an option. It's just not the way this file works, for various reasons that would take too long to describe. I've just got to believe there's a way to effective take an array and (formulaically, not VBA) use the rows as I would any set of rows in Excel, whereby I can take the Xth column, and sum all amounts in that column.
Thanks for the idea of separating into pivots. Again, just not in the cards for this file, for a host of reasons.