<div>
Hi,<br />
<br />
Sorry, how does a value of 4 (or 7) relate to the specific starting columns/rows you have stated?<br />
<br />
Also, where is 4 entered in column U? &nbsp;Which row?<br />
<br />
BFN,<br />
<br />
fp.
</div>


Hi,

Sorry, how does a value of 4 (or 7) relate to the specific starting columns/rows you have stated?

Also, where is 4 entered in column U?  Which row?

BFN,

fp.

<div>
apologies fp<br />
<br />
Assume 4 is entered in row 7 column U <br />
<br />
and then we want to sum up the data in column C7:F7...
</div>


apologies fp

Assume 4 is entered in row 7 column U

and then we want to sum up the data in column C7:F7...

Q-28244877.xls

<div>
Hi,<br />
<br />
To be able to use the formula in different rows <br />
pls use<br />
<br />
=SUM(INDIRECT(&quot;R&quot;&amp;ROW(P6)&amp;<wbr />&quot;C&quot;&amp;3&amp;&quot;:&quot;&amp;<wbr />&quot;R&quot;&amp;ROW(P6<wbr />)&amp;&quot;C&quot;&amp;2+P6<wbr />,FALSE))<br />
<br />
Regards
</div>


Hi,

To be able to use the formula in different rows
pls use

=SUM(INDIRECT("R"&ROW(P6)&"C"&3&":"&"R"&ROW(P6)&"C"&2+P6,FALSE))

Regards

<div>
...or, place this formula in cell [U7]:<br />
=SUM(INDIRECT(ADDRESS(ROW(<wbr />),3)&amp;&quot;:&quot;&amp;A<wbr />DDRESS(ROW<wbr />(),3+U7-1)<wbr />))<br />
<br />
...and copy down column [ U ] to any other row.<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/09_w38/678414/Q-28244877b.xls" target="_blank" class="file-inline" title="Q_28244877b (27 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Q-28244877b.xls</a>
</div>


...or, place this formula in cell [U7]:
=SUM(INDIRECT(ADDRESS(ROW(),3)&":"&ADDRESS(ROW(),3+U7-1)))

...and copy down column [ U ] to any other row.
Q-28244877b.xls [https://filedb.experts-exchange.com/incoming/2013/09_w38/678414/Q-28244877b.xls]

Q-28244877b.xls

<div>
<div class="content wysiwyg-content">
Hi Experts (excel 2007)<br />
<br />
I need a sum formula to sum across the data in a set number of columns based on what number i enter in column U<br />
<br />
So if i enter in column u 4 then &gt;<br />
<br />
starting at column 6C (always) sum columns 6C:6F and enter result in column P<br />
<br />
So if i enter in Column u 7 then&gt;<br />
<br />
Staring at column 6C (always) sum Columns 6C:6I etc....
</div>
</div>


Hi Experts (excel 2007)

I need a sum formula to sum across the data in a set number of columns based on what number i enter in column U

So if i enter in column u 4 then >

starting at column 6C (always) sum columns 6C:6F and enter result in column P

So if i enter in Column u 7 then>

Staring at column 6C (always) sum Columns 6C:6I etc....

formula to sum columns based a value in a given column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.