SUMPRODUCT

[Karen]

I have the following formula in a cell:
=SUMPRODUCT(--((J3:J42="Released")+(M3:M42="Released")+
(P342="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!

 

[Arvi Laanemets]

Hi

=COUNTIF(J3:J42,"Released")+COUNTIF(M3:M42,"Released")+COUNTIF(P342,"Relea
sed")


Arvi Laanemets

 

[Ragdyer]

This works for me:

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

OR
With "Released" entered in J1:

=SUMPRODUCT((J3:J42=J1)+(M3:M42=J1)+(P342=J1))