• #VALUE! error in SUMIF formula


    I am trying to create a SUMIF formula using nonadjacent ranges and I am getting a #VALUE! error.

    What is wrong? the formula works with adjacent ranges in the form A1:A5. I am trying to add a row of numbers if the cell in the reference row is not empty.

    Viewing 0 reply threads
    • #510122

      If one of the cells contains text (eg blank space), then the sum() would fail because it only adds numbers.
      But also, SUMIF() seems to like a coherent range (A3:I3)rather than the intermediate ones

    Viewing 0 reply threads
    Reply To: #VALUE! error in SUMIF formula

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: