• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    SUMIFS formula returns #Value!

    I found out what I was doing wrong: This is the formula that I was using: =SUMIFS(E3:E12,A3:D12,A63,F3:H12,A64) The problem was I am using merged cells and when I was usign the wizard to help with the formula, I was dragging down the column and grabbing all of the cells and that was...
  2. A

    SUMIFS formula returns #Value!

    I am trying to us the SUMIFS the formula to sum the values in one column based on the values in two other columns. I am using the wizard and everytime I complete the formula, I get the #Value! as a result. In checking on #Value! it states that there is a disparity between data types in the...
Back
Top