Ask Your Question
0

SUMPRODUCT "Div/0" ERROR WITH NO DIVISION

asked 2019-06-12 03:46:53 +0200

VeganGio gravatar image

HI.

How come I get a "div/0" error with the following formula as there's no division?

SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,Z1:Z10)

Basically, I'm trying to sum the products of S(1→10)*Z(1→10) only if the values in the column B are the same as the value in A1 and the value in column C are "EX". Each column may contain a number, text or nothing.

Regardless, I'm puzzled by the "div/0" error.

edit retag flag offensive close merge delete

Comments

Do you think that it's enough to write that to others could reproduce your problem? It's required to provide a sample ODS instead, and that would be worth hundreds words. The only thing required to supplement the sample file would be telling which cell contains bad result in your opinion, your OS and LO versions. That's all.

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-12 05:36:05 +0200 )edit

My guess: there is somewhere in [B|C|S|Z]1…10 a #div/0-error which goes straight into return of SUMPRODUCT

karolus gravatar imagekarolus ( 2019-06-12 09:25:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-12 09:38:17 +0200

karolus gravatar image

updated 2019-06-12 09:42:58 +0200

Hallo

See my Comment, if so - try something like:
=SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,IFERROR(Z1:Z10,0))

…or eliminate the #div/0 errors individually.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-12 03:46:53 +0200

Seen: 37 times

Last updated: Jun 12