# SUMPRODUCT ERROR

1. ## 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

2. ## RE: SUMPRODUCT ERROR

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

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1