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