Sum part of a row in a two dimensional array

[JasperD]

Hi guys,

is there an easy way to sum part of a row of a two dimensional array in memory?

Situation:
1) I put 150 rows by 130 columns of the worksheet into an array in memory
2) I do webscrapes and paste the results into the array rather than the worksheet
3) I want to sum part of each row (for example, row 20, columns 24:27) and store that into column 23 of row 20 in the array

when I'm all done, I paste this back into the worksheet.

My array is called 'sht'

I tried the following, but that doesn't work.

sht(20, 23) = Application.Sum(Sht(20,24),Sht(20, 27))

What am I doing wrong here?

[PCI]

Perhaps try

   Sht(20, 23) = Application.Sum(Application.Index(Sht, 20, [{24,25,26,27}]))

[nilem]

maybe just

sht(20, 23) = sht(20, 24) + sht(20, 25) + sht(20, 26) + sht(20, 27)

[JasperD]

Thanks, PCI, that works flawlessly!

[JasperD]

Thanks PCI & nilem,

the problem is that the '24' and '27' are coming from variables.

So it actually is as below

sht(20, 23) = application.sum(sht(20, x), sht(20, y))

my apologies, I should have made that clear in my original post.

I know I could loop through it, by saying

z = x
do until z = y + 1
sht(20, 23) = sht (20, 23) + sht(20,z)
z = z + 1
loop

But I prefer to not loop

[PCI]

Try again

   Sht(20, 23) = Application.Sum(Application.Index(Sht, 20, Evaluate("row(" & x & ":" & y & ")")))

[PCI]

Good news, you're welcome.