Sumproduct from array

[Macro1]

Hi,

I'm currently pulling through data from SQL and holding it in an array. What I want to do is write a line of code that will Sumproduct Column 3 againts Column 4 and return the value to a cell (say A1)

If anybody could advise me with this method it would be much appreciated as I'm a bit stuck.

Thanks in Advance

Macro1

[DonkeyOte]

Perhaps

Please Login or Register  to view this content.

where vArray is your Array.

[Richard Schollar]

If you are using the ADO method GetRows to populate your array, just be aware that it reverses the 'normal' excel order of 2D arrays of 1st dimension being rows, 2nd being columns, so you may need to swap the row/column indices around in DO's code.

Why don't you perform this calculation actually within the SQL itself?

[Macro1]

Thanks Guys,

To be honest I didn't even think to perform the task in SQL, it seemed obvious after I read your reply.

Thanks Again