I have the following formula that gets to tolas for January SEARS:

=SUMPRODUCT(--('SEARS Source'!$A$5:$A$410=(LEFT(C$6,1))),--('SEARS

Source'!$B$5:$B$410=$B80),'SEARS Source'!$C$5:$C$410)

result comes up #DIV/0!

Then I have This Formula that gets the totals for February SEARS

=SUMPRODUCT(--('SEARS Source'!$A$5:$A$410=(LEFT(D$6,1))),--('SEARS

Source'!$B$5:$B$410=$B80),'SEARS Source'!$F$5:$F$410)

Result is the correct units.

Why If there are the same formula and geting data from diferent Columns one

gets the date and the other does not

NOTE =(LEFT(D$6,1)) is = B

NOTE =(LEFT(C$6,1)) is = B also

## Bookmarks