SUMPRODUCT
 

I have the following formula in a cell:
=SUMPRODUCT(--((J3:J42="Released")+(M3:M42="Released")+
(P3:P42="Released")0))
It's not doing what it's supposed to do.
I actually have a total of 9 Released cells and it's only
showing a sum of 7.

I noticed that 2 rows out of the above range have more
than one "Released" - It's only adding the total released
if there is only one "Released" in a row and I need to
sum them all.

HELP!

Hi

=COUNTIF(J3:J42,"Released")+COUNTIF(M3:M42,"Releas ed")+COUNTIF(P3:P42,"Relea
sed")


Arvi Laanemets


"Karen" wrote in message
...
I have the following formula in a cell:
=SUMPRODUCT(--((J3:J42="Released")+(M3:M42="Released")+
(P3:P42="Released")0))
It's not doing what it's supposed to do.
I actually have a total of 9 Released cells and it's only
showing a sum of 7.

I noticed that 2 rows out of the above range have more
than one "Released" - It's only adding the total released
if there is only one "Released" in a row and I need to
sum them all.

HELP!

This works for me:

=SUMPRODUCT((J3:J42="Released")+(M3:M42="Released" )+(P3:P42="Released"))

OR
With "Released" entered in J1:

=SUMPRODUCT((J3:J42=J1)+(M3:M42=J1)+(P3:P42=J1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Karen" wrote in message
...
I have the following formula in a cell:
=SUMPRODUCT(--((J3:J42="Released")+(M3:M42="Released")+
(P3:P42="Released")0))
It's not doing what it's supposed to do.
I actually have a total of 9 Released cells and it's only
showing a sum of 7.

I noticed that 2 rows out of the above range have more
than one "Released" - It's only adding the total released
if there is only one "Released" in a row and I need to
sum them all.

HELP!