+ Reply to Thread
Results 1 to 3 of 3

SUMPRODUCT

  1. #1
    Karen
    Guest

    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. #2
    Arvi Laanemets
    Guest

    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. #3
    Ragdyer
    Guest

    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!



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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