# SUMPRODUCT

1. ## 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!

2. ## Re: SUMPRODUCT

Hi

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

Arvi Laanemets

"Karen" <anonymous@discussions.microsoft.com> wrote in message
news:238e01c51f6b\$81099de0\$a501280a@phx.gbl...
> 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!

3. ## Re: SUMPRODUCT

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" <anonymous@discussions.microsoft.com> wrote in message
news:238e01c51f6b\$81099de0\$a501280a@phx.gbl...
> 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!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1