• 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. P

    SUMIF formula conversion for Excel 2003

    Thanks kanti I spent so long trying to find the SUMIFS solution my brain couldn't contemplate an easy solution as you have suggested. Thanks again.
  2. P

    SUMIF formula conversion for Excel 2003

    Thanks kchiba. It does work, i was just looking up the SUMPRODUCT topic and was nearly at that answer. Appreciate your help. Is there any way to also give the number of cells used in $N:$N, like the COUNTIFS function?
  3. P

    SUMIF formula conversion for Excel 2003

    Could i please get some help with using the following formula in excel2003 =SUMIFS(Sheet2!$D:$D,Sheet2!$N:$N,B3,Sheet2!$B:$B,A4)
Back
Top