MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Sumproduct using ADO

  Asked By: Phil    Date: Aug 15    Category: MS Office    Views: 702

I want to use the function sumproduct for an external data.
If I retrieve the data using ODBC (microsoft query) the function
works fine, but if I retrieve using ADO (VBA), the sumproduct will
fail summing the data. Fyi both of the data using ODBC and ADO are
actually the same. Can somebody help me?



1 Answer Found

Answer #1    Answered By: Brandon Tucker     Answered On: Aug 15

How are you using SumProduct()? Can you mention a line of code?

Didn't find what you were looking for? Find more on Sumproduct using ADO Or get search suggestion and latest updates.