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...
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)...
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...