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).
06-05-2018, 06:30 AM
Similar Threads
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
Windows 8 
Office 2016
Threaded Mode