=SUMPRODUCT...

D

DUH

Trying to calculate how many times data occurs in columns
f,g,t

=SUMPRODUCT((F6:F200="F"),--(G6:G200="C"),--(T6:T200=1))

and

how many times data occurs in coluns g,t

=SUMPRODUCT(--(G6:G200="C"),(T6:T200="1"))

It is not working.... WHy??????
 
J

JulieD

Hi

try
=SUMPRODUCT(--(F6:F200="F"),--(G6:G200="C"),--(T6:T200=1))
and
=SUMPRODUCT(--(G6:G200="C"),(T6:T200=1))

Cheers
JulieD
 
F

Frank Kabel

Hi
what does exacty not work?. Wrong results, error code. At least your
second formula should be:
=SUMPRODUCT(--(G6:G200="C"),--(T6:T200=1))

if column t stores numeric values
 
D

DUH

Thanks Frank. The results always show up as zero. "1" is
as text (no better than "x")
 
F

Frank Kabel

Hi
then use
=SUMPRODUCT(--(G6:G200="C"),--(T6:T200="1"))

and for the first formula:
=SUMPRODUCT(--(F6:F200="F"),--(G6:G200="C"),--(T6:T200="1"))
 
D

DUH

That's a no go on either. Still getting zero.
-----Original Message-----
Hi

try
=SUMPRODUCT(--(F6:F200="F"),--(G6:G200="C"),--(T6:T200=1))
and
=SUMPRODUCT(--(G6:G200="C"),(T6:T200=1))

Cheers
JulieD





.
Click to expand...
 
D

DUH

Ok, I thought I was stupid, but that is what I did the
first time. Now it works. Just like you techies to come
in and fix it without a sweat.

Danke
Duh.
 
J

JulieD

Does Frank's latest suggestion work? .. .i assumed that the 1 was numeric
not text .. .so it should have the quotes around it
=SUMPRODUCT(--(F6:F200="F"),--(G6:G200="C"),--(T6:T200="1"))
and
=SUMPRODUCT(--(G6:G200="C"),(T6:T200="1"))


Cheers
JulieD
 
J

JE McGimpsey

SUMPRODUCT requires numeric ranges. The comparison returns a boolean
(TRUE/FALSE) array. One unary minus operator coerces the TRUE/FALSE
array to -1/0s, respectively. The second unary minus negates -1/0 to 1/0.
 
Top