SUMPRODUCT and OR?

  • Thread starter Thread starter Rune
  • Start date Start date
R

Rune

How do you count rows from criterias in two columns where the criteri
shall be OR? I.e. something lik
SUMPRODUCT(('[jisses.xls]Requirements'!$E$2:$E$10000="Car")+('[jisses.xls]Requirements'!$F$2:$F$10000="Car"))
but where you get a count on number of rows where either (both column
are = Car) or (any of the columns are = Car)?
 
Rune,

Try

=SUMPRODUCT(('[jisses.xls]Requirements'!$E$2:$E$10000="Car")+('[jisses.xls]R
equirements'!$F$2:$F$10000="Car"))-SUMPRODUCT(('[jisses.xls]Requirements'!$E
$2:$E$10000="Car")*('[jisses.xls]Requirements'!$F$2:$F$10000="Car")),


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob Phillips said:
=SUMPRODUCT(('[jisses.xls]Requirements'!$E$2:$E$10000="Car")
+('[jisses.xls]Requirements'!$F$2:$F$10000="Car"))
-SUMPRODUCT(('[jisses.xls]Requirements'!$E$2:$E$10000="Car")
*('[jisses.xls]Requirements'!$F$2:$F$10000="Car")),
Click to expand...

OK, but

=SUMPRODUCT(--(('[jisses.xls]Requirements'!$E$2:$E$10000="Car")
+('[jisses.xls]Requirements'!$F$2:$F$10000="Car")>0))

would suffice.
 
Back
Top