SUMPRODUCT ERROR
 

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

If you have a div error somewhere in either B5:B410 or C5:C410 you will get
that result (I assume there are text values in column A), so to get rid of
that change the formulas that retrun the error, as an example if you have
something like

=A1/B1

change to

=IF(B1=0,0,A1/B1)


Regards,

Peo Sjoblom

"Mestrella31" wrote:

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