<div>
<div class="content wysiwyg-content">
The column B is a datatable from Access. The field is text format, as is $D$1 cell.<br />
The result of the formula is 0. <br />
HOWEVER, if I TYPE in the same data into any cell in column B, I will get the correct result from the formula.<br />
<br />
For instance, the data in B is 120 and the result is 0.<br />
If I simply TYPE in 120, it calculates correctly.<br />
<br />
Also, &nbsp;I am using a countif formula using the same column and IT calculates accurately.<br />
<br />
Can anyone help???<br />
<br />
=SUMPRODUCT(($B$13:$B$1048<wbr />576=$D$1)*<wbr />($H$13:$H$<wbr />1048576=&quot;E<wbr />xpress&quot;)*(<wbr />$E$13:$E$1<wbr />048576))
</div>
</div>


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???

=SUMPRODUCT(($B$13:$B$1048576=$D$1)*($H$13:$H$1048576="Express")*($E$13:$E$1048576))

Sumproduct not reading data from datatable

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.