• 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


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

Please help - Sum amount with various conditions or criteria

Not open for further replies.



Please can someone help me.

In the attached spreadsheet, i am looking for a formula in the summary tab in cell E13 which will look at the value or text in cell C6 (summary tab) then compare it to the range of the same value or text in the costs tab from cells C6:C219 and also look at the value in summary tab cell c12 and compare it to the values in the costs tab from range C6:C219 and then add all the amounts from the costs tab in relation to the code and cost centre only.



Excel Ninja
Why did You duplicate Your thread?
You got one sample solution, if that won't work for You then You should able to give more details there.
This thread is closed.
Not open for further replies.