Sumproduct not reading data from datatable
Posted on 2012-08-14
The column B is a datatable from Access. The field is text format, as is $D$1 cell.
The result of the formula is 0.
HOWEVER, if I TYPE in the same data into any cell in column B, I will get the correct result from the formula.
For instance, the data in B is 120 and the result is 0.
If I simply TYPE in 120, it calculates correctly.
Also, I am using a countif formula using the same column and IT calculates accurately.
Can anyone help???