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

    2D SUMIF with both ROW COLUMN criteria

    Thanks Hui. I've managed to get a working version by performing a SUMIF based on Contract Number (Col A) and storing this as a new ROW for each contract and then use the date comparison functions to work out the two values (it actually helps to see the contract line details as a summary in any...
  2. S

    2D SUMIF with both ROW COLUMN criteria

    Thank you for your replies Hui & Dan, and sorry for not getting back to you sooner. I will take a look at the =Sumproduct option, from a data perspective I'm not sure how to upload a file onto the forum but lets say I have the following: Col A = Contract Number (I have multiple contracts)...
  3. S

    2D SUMIF with both ROW COLUMN criteria

    Hi Folks, I have been looking with great interest at the SUMIF postings on the site and wondered if there is an elegant way to deal with both row and column criteria to sum only certain cells which intersect with both row & column criteria. Let me explain further. For each row I have...
Back
Top