SUMPRODUCT ERROR #DIV/0!

[mestrella31]

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

 

[Brian from Maui]

Do you have a #DIV/0! in any of your ranges?

 

[mestrella31]

Do you have a #DIV/0! in any of your ranges?

Thnaks That Works