montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 984
- Office Version
- 2010
- Platform
- Windows
hello everyone. I am trying to understand about loops, so I want to see, what loop to use if I need to sum an array row by row, I am learning by myself. I want to see if you use, for...next or do while or ???. .
Code:
[TABLE="width: 384"]
<colgroup><col width="64" style="width: 48pt;" span="8"> <tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]5[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]6[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, width: 64, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]7[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]8[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]9[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]10[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]11[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]12[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]57[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]13[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]14[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]15[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]16[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]17[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]18[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]93[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]19[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]20[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]21[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]22[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]23[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]24[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]129[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]25[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]26[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]27[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]28[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]29[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]30[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]165[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]31[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]32[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]33[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]34[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]35[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]36[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]201[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]37[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]38[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]39[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]40[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]41[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]42[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]237[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]43[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]44[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]45[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]46[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]47[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]48[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]273[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]49[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]50[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]51[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]52[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]53[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]54[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]309[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]55[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]56[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]57[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]58[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]59[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]60[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]345[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]61[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]62[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]63[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]64[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]65[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]66[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]381[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]67[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]68[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]69[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]70[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]71[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]72[/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[TD="class: xl63, bgcolor: transparent, align: right"][FONT=Calibri][SIZE=3][COLOR=#000000]417[/COLOR][/SIZE][/FONT][/TD]
[/TR]
</tbody>[/TABLE]