Quote:
Originally Posted by Pecoflyer
|
As the formula will be obviously in single cell, it will be no problem at all!
Quote:
|
Is that O7 reference correct?
|
I checked sums for different possibilities and made a comparison with OP's sum. As result I decided, that B12 is number of start column in datarange (L4:Q7), and D12 is number of columns to sum.
Btw, the formula using OFFSET allows to use 4 parameters to select the sum range. OP can determine the row from where summarizing begins (currently fixed at 4), and the number of rows to summarize (currently fixed at 1).