WorkSheet Function with Multi Dimensional Array

Hi to all

I'm having troubles understanding how to use a Multi Dimensional Array to feed a worksheet function. I'm trying to use the SumXMY2 function like this:

Please Login or Register  to view this content.

I wanted to use the first and second dimension of MyArray to feed the SumXMY2.
Can anyone tell me please if this is possible?
The above code not my real case, I'm not filling the array, I'm using GetRows to retrieve and array from a DAO recordset.

Thanks in advance.

Thanks a lot DonkeyOte, that works great.