SUM-Formula.xlsx

<div>
Or do you want it to consider other values for a?
</div>


Or do you want it to consider other values for a?

<div>
=IF(condition, result if true, result if false)<br />
<br />
so, here it would be :<br />
=IF(a=3, sum(B2:D2), IF(a=2, sum(B2:C2), 0))<br />
<br />
if a is neither 3 or 2 then the result is 0<br />

</div>


=IF(condition, result if true, result if false)

so, here it would be :
=IF(a=3, sum(B2:D2), IF(a=2, sum(B2:C2), 0))

if a is neither 3 or 2 then the result is 0


<div>
Where will the parameter come from<br />
<br />
If it is in say cell a2 you could use something like<br />
<br />
=SUM(INDIRECT(ADDRESS(1,2)<wbr />):INDIRECT<wbr />(ADDRESS(1<wbr />,2+ A2)))<br />
<br />
Michael<br />
<br />

</div>


Where will the parameter come from

If it is in say cell a2 you could use something like

=SUM(INDIRECT(ADDRESS(1,2)):INDIRECT(ADDRESS(1,2+ A2)))

Michael



<div>
=SUMIF(B1:F1,&quot;&lt;&quot;&amp;A3,B2:F2)<wbr /><br />
for example assuming your value (3 or 2 or whatever) is in A3.
</div>


=SUMIF(B1:F1,"<"&A3,B2:F2)
for example assuming your value (3 or 2 or whatever) is in A3.

<div>
Typo:<br />
=SUMIF(B1:F1,&quot;&lt;=&quot;&amp;A3,B2:F2<wbr />)
</div>


<div>
...or you could use INDEX, something like<br />
<br />
=SUM(B2:INDEX(B2:Z2,A3))<br />
<br />
regards, barry
</div>


...or you could use INDEX, something like

=SUM(B2:INDEX(B2:Z2,A3))

regards, barry

<div>
<div class="content wysiwyg-content">
My excel file:<br />
<br />
DATE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
TTL Cast target &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,082 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,173 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,520 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,245 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,286 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,184 <br />
<br />
<br />
<br />
<br />
My parameter: &nbsp;a<br />
If a = 3 --&gt; =sum(B2:D2)<br />
if a = 2 --&gt; = sum(B2:C2)<br />
<br />
How can I do it?<br />
<br />

</div>
</div>


My excel file:

DATE		                  1	             2	            3	            4	             5	              6
TTL Cast target		 1,082 	 2,173 	 1,520 	 2,245 	 2,286 	 2,184 




My parameter:  a
If a = 3 --> =sum(B2:D2)
if a = 2 --> = sum(B2:C2)

How can I do it?



Excel dynamic sum.

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