Results 1 to 2 of 2

Thread: What is wrong with this sumproduct formula?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2004
    Posts
    774
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default What is wrong with this sumproduct formula?

    What is wrong with this formula? I should be getting a result of 104 but i get no value returned. No error in the cell either. The cell is blank.

    =SUMPRODUCT(($I$3:$I$2000="")*($E$3:$E$2000="51014")*($K$3:$K$2000)+($I$3:$I$2000="")*($E$3:$E$2000="51010")*($K$3:$K$2000))

    I'm asking it to read column "I" and if a cell is blank in column "I"..then read column "E" and if there is a 51014 OR a 51010 in its adjoining cell then give me the value in column "K"
    Marq

  2. #2
    Board Regular
    Join Date
    Dec 2004
    Posts
    774
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What is wrong with this sumproduct formula?

    i figured it out...I had to remove the quotes from 51014 and 51010
    Marq

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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