VBA: Multi-dimensional array sum/mean/stdev

[Ells_]

I have a quick question that I couldn't quite find when searching for it.
I have a 3 dimensional array myArray(x,y,z), with x & y being input and z being output data in my case. I want to use different functions on myArray(x,y,, where : is all z values. example: cell(x,y) = sum(myArray(x,y,). I know I can do this with a (triple) loop, but I was wondering if there was an easier way to do this, since I know you can with 1-dimensional arrays

Thanks

 

[shg]

Is it really a 3D array, or a 2D array (1 to n, 1 to 3)?

 

[Ells_]

Is it really a 3D array, or a 2D array (1 to n, 1 to 3)?

It is a 3D array. The first two dimensions are constant, and 3rd is the data itself. ex: myArray(1,1,data_points). The 3rd dimension is the same for every x and y.

 

[shg]

I guess I'm missing what you're doing.

If you have a list of triplets {x,y,z}, you only need a 2D array to store it.

If you had a table with x values across the top, y values down the side, and z values in the body of the table, you would use 1D arrays for x and y, and a 2D array for z.

In any case, none of the worksheet functions will work on 3D arrays.

 

[Ells_]

I guess I'm missing what you're doing.

If you have a list of triplets {x,y,z}, you only need a 2D array to store it.

If you had a table with x values across the top, y values down the side, and z values in the body of the table, you would use 1D arrays for x and y, and a 2D array for z.

In any case, none of the worksheet functions will work on 3D arrays.

I guess I'll reword my description of my problem.
I have a myArray(x,y,z). If I input x and y, it will take the sum/average/stdev of all the z data of that x,y.

myArray(1,3,1) = 1
myArray(1,3,2) = 2
myArray(1,3,3) = 3

sum(myArray(1,3,1:3)) = 6
^ something that has this functionality is what I'm after. I just want to see if there's a way to do it without having to loop through everything

 

[shg]

I know of no way other than a loop for 3D arrays. The worksheet functions you might use (e.g., Index, to get a slice of a 2D array) don't work on 3D arrays.