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?