=SUMPRODUCT...

[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??????

 

[JulieD]

Hi

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

Cheers
JulieD

 

[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

 

[DUH]

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

 

[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"))

 

[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





.

 

[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.

 

[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

 

[Theo Bartley]

What does the "--" in the formula do?
Thanks,
Theo

 

[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.