Cumulative total across columns and specifying which columns to include using a variable

O

orangebloss

Board Regular
Joined
Jun 5, 2013
Messages
51
Office Version
  1. 365
Platform
  1. Windows
Hi

I've got a set of data that each week I need to run a report to see what the cumulative total should be
Is there a way I can do this in a formula?

[table="width: 500"]
[tr]
[td]A[/td]
[td]B[/td]
[td]C[/td]
[td]D[/td]
[td]E[/td]
[/tr]
[tr]
[td]1[/td]
[td]17/04[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]2[/td]
[td]17/02[/td]
[td]17/03[/td]
[td]17/04[/td]
[td]17/05[/td]
[/tr]
[tr]
[td]3[/td]
[td]15[/td]
[td]10[/td]
[td]20[/td]
[td]10[/td]
[/tr]

[/table]

I would like to perform a total based on the value in B1 :
Sum values that are in the columns preceeding the column with the title in B1 (i.e. 15+10 )
Sum values that are in the columns from the column with the title in B1 (i.e. 20+10)

Any advice?

Thanks in advance

C
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Somebody will probably come up with an easier solution, but until that happens, please try this. I assumed you wanted to eventually add up more rows of data in each column so I created some dummy data. Cells A2 and B2 are the answer. Column A and B are added to summarize the values. Range C2:F2 are formulas to test based on the value in C1.

Jeff


Excel 2012
ABCDEF
17/04
BeforeBeforeAfterAfter
BeforeAfter17/0217/0317/0417/05

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]697[/TD]
[TD="align: right"]782[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]11[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]15[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]16[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]17[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]18[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]19[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]21[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]22[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]23[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]24[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]26[/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A2[/TH]
[TD="align: left"]=SUM(A4:A20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B2[/TH]
[TD="align: left"]=SUM(B4:B20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=IF(C3<$C$1,"Before","After")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=IF(D3<$C$1,"Before","After")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=IF(E3<$C$1,"Before","After")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=IF(F3<$C$1,"Before","After")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A4[/TH]
[TD="align: left"]=SUMIFS(C4:F4,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B4[/TH]
[TD="align: left"]=SUMIFS(C4:F4,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A5[/TH]
[TD="align: left"]=SUMIFS(C5:F5,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B5[/TH]
[TD="align: left"]=SUMIFS(C5:F5,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A6[/TH]
[TD="align: left"]=SUMIFS(C6:F6,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B6[/TH]
[TD="align: left"]=SUMIFS(C6:F6,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A7[/TH]
[TD="align: left"]=SUMIFS(C7:F7,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B7[/TH]
[TD="align: left"]=SUMIFS(C7:F7,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A8[/TH]
[TD="align: left"]=SUMIFS(C8:F8,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B8[/TH]
[TD="align: left"]=SUMIFS(C8:F8,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A9[/TH]
[TD="align: left"]=SUMIFS(C9:F9,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B9[/TH]
[TD="align: left"]=SUMIFS(C9:F9,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A10[/TH]
[TD="align: left"]=SUMIFS(C10:F10,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B10[/TH]
[TD="align: left"]=SUMIFS(C10:F10,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A11[/TH]
[TD="align: left"]=SUMIFS(C11:F11,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B11[/TH]
[TD="align: left"]=SUMIFS(C11:F11,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A12[/TH]
[TD="align: left"]=SUMIFS(C12:F12,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B12[/TH]
[TD="align: left"]=SUMIFS(C12:F12,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A13[/TH]
[TD="align: left"]=SUMIFS(C13:F13,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B13[/TH]
[TD="align: left"]=SUMIFS(C13:F13,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A14[/TH]
[TD="align: left"]=SUMIFS(C14:F14,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B14[/TH]
[TD="align: left"]=SUMIFS(C14:F14,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A15[/TH]
[TD="align: left"]=SUMIFS(C15:F15,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B15[/TH]
[TD="align: left"]=SUMIFS(C15:F15,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A16[/TH]
[TD="align: left"]=SUMIFS(C16:F16,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B16[/TH]
[TD="align: left"]=SUMIFS(C16:F16,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A17[/TH]
[TD="align: left"]=SUMIFS(C17:F17,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B17[/TH]
[TD="align: left"]=SUMIFS(C17:F17,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A18[/TH]
[TD="align: left"]=SUMIFS(C18:F18,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B18[/TH]
[TD="align: left"]=SUMIFS(C18:F18,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A19[/TH]
[TD="align: left"]=SUMIFS(C19:F19,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B19[/TH]
[TD="align: left"]=SUMIFS(C19:F19,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A20[/TH]
[TD="align: left"]=SUMIFS(C20:F20,$C$2:$F$2,A$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B20[/TH]
[TD="align: left"]=SUMIFS(C20:F20,$C$2:$F$2,$B$3)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C5[/TH]
[TD="align: left"]=1+C4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D5[/TH]
[TD="align: left"]=1+D4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E5[/TH]
[TD="align: left"]=1+E4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F5[/TH]
[TD="align: left"]=1+F4[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C6[/TH]
[TD="align: left"]=1+C5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D6[/TH]
[TD="align: left"]=1+D5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E6[/TH]
[TD="align: left"]=1+E5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F6[/TH]
[TD="align: left"]=1+F5[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C7[/TH]
[TD="align: left"]=1+C6[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D7[/TH]
[TD="align: left"]=1+D6[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E7[/TH]
[TD="align: left"]=1+E6[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F7[/TH]
[TD="align: left"]=1+F6[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C8[/TH]
[TD="align: left"]=1+C7[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D8[/TH]
[TD="align: left"]=1+D7[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E8[/TH]
[TD="align: left"]=1+E7[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F8[/TH]
[TD="align: left"]=1+F7[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C9[/TH]
[TD="align: left"]=1+C8[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D9[/TH]
[TD="align: left"]=1+D8[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E9[/TH]
[TD="align: left"]=1+E8[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F9[/TH]
[TD="align: left"]=1+F8[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C10[/TH]
[TD="align: left"]=1+C9[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D10[/TH]
[TD="align: left"]=1+D9[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E10[/TH]
[TD="align: left"]=1+E9[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F10[/TH]
[TD="align: left"]=1+F9[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C11[/TH]
[TD="align: left"]=1+C10[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D11[/TH]
[TD="align: left"]=1+D10[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E11[/TH]
[TD="align: left"]=1+E10[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F11[/TH]
[TD="align: left"]=1+F10[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C12[/TH]
[TD="align: left"]=1+C11[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D12[/TH]
[TD="align: left"]=1+D11[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E12[/TH]
[TD="align: left"]=1+E11[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F12[/TH]
[TD="align: left"]=1+F11[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C13[/TH]
[TD="align: left"]=1+C12[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D13[/TH]
[TD="align: left"]=1+D12[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E13[/TH]
[TD="align: left"]=1+E12[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F13[/TH]
[TD="align: left"]=1+F12[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C14[/TH]
[TD="align: left"]=1+C13[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D14[/TH]
[TD="align: left"]=1+D13[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E14[/TH]
[TD="align: left"]=1+E13[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F14[/TH]
[TD="align: left"]=1+F13[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C15[/TH]
[TD="align: left"]=1+C14[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D15[/TH]
[TD="align: left"]=1+D14[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E15[/TH]
[TD="align: left"]=1+E14[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F15[/TH]
[TD="align: left"]=1+F14[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C16[/TH]
[TD="align: left"]=1+C15[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D16[/TH]
[TD="align: left"]=1+D15[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E16[/TH]
[TD="align: left"]=1+E15[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F16[/TH]
[TD="align: left"]=1+F15[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C17[/TH]
[TD="align: left"]=1+C16[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D17[/TH]
[TD="align: left"]=1+D16[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E17[/TH]
[TD="align: left"]=1+E16[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F17[/TH]
[TD="align: left"]=1+F16[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C18[/TH]
[TD="align: left"]=1+C17[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D18[/TH]
[TD="align: left"]=1+D17[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E18[/TH]
[TD="align: left"]=1+E17[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F18[/TH]
[TD="align: left"]=1+F17[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C19[/TH]
[TD="align: left"]=1+C18[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D19[/TH]
[TD="align: left"]=1+D18[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E19[/TH]
[TD="align: left"]=1+E18[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F19[/TH]
[TD="align: left"]=1+F18[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C20[/TH]
[TD="align: left"]=1+C19[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D20[/TH]
[TD="align: left"]=1+D19[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E20[/TH]
[TD="align: left"]=1+E19[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F20[/TH]
[TD="align: left"]=1+F19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
New formula for cumulative values
Replies
6
Views
195
djclements
djclements
SFCChase
  • Question Question
Use Dropdown to search other tabs
Replies
4
Views
167
SFCChase
SFCChase
F
  • Solved
Formula to find location of second row from the bottom containing specific text
Replies
5
Views
109
Peter_SSs
Peter_SSs
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
423
dshtesy
D
M
  • Question Question
How to sum cells in a column that match an End of Month date in an adjacent column
Replies
7
Views
261
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top