Ask Your Question


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

VeganGio gravatar image


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


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

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

karolus gravatar image

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


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


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

Seen: 37 times

Last updated: Jun 12