Summing Array elements

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I have a 9 element array which stores integer values. What I would like to be able to do is to add up the individual elements, and then store the value in another integer variable.

Can this be done without having to explicitly add up each element?

e.g instead of saying for eg,

Dim x( as Integer
Dim xTotal as Integer

xTotal = x(0) + x(1) + x(2)....+ x(

can I have something like

xTotal = Sum(x(0)()

which of course is similar to how you would add up the values in a range of cells in a spreadsheet. I know the former would work, but the latter looks tidier!

Edit (SG) Removed Smilies!

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Oh dear.. Poxy smilies!

 

Fixed the smilies for you Phil!

 

Which language are you intending to use here? It makes a difference!

Harry.

 

hmmm lets see if i understand what you want.. you have an array with 8 elements and you want to add them all up without say:

x=array[1]+array[2].....

well if this is it.. why not use a loop? aka conditional statement..

 

Use the code tags and you wont get the smiles in your text. Hight light your code and hit the code tags buttton . HTH