• 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 in 2003

    IT WORKED!!!!! THANK YOU SO MUCH!!!
  2. A

    SUMIFS in 2003

    Hi SirJB7, The original formula is actually: =SUMIF((J11:J149="In process")*(B11:B149=A3),I11:I149,0) That last part wasnt =0 it was ,0. But, this formula works perfectly! I just need to find something that replaces SUMIFS!!!! =SUMIFS(I11:I391,K11:K391,"February",J11:J391,"In process")
  3. A

    SUMIFS in 2003

    Hi SirJB7, Unfortunatley, it just outputs "0" instead of adding the same as SUMIFS would. Thanks for trying though!! Andrew
  4. A

    SUMIFS in 2003

    Hello All, I know that SUMIFS doesnt exsist in 2003, so I need to rework my formula- I just cant figure out how to fix it! If I change it to SUMIFS and try it in 2007 it works fine. =SUMIF((J11:J149="In process")*(B11:B149=A3),I11:I149,0) Any help would be greatly appreciated!! Andrew
Back
Top