Posted by Jenny Conte on January 24, 2001 6:28 AM
I think I'm almost there, but the following fomula is giving me a result of 0 which is not correct, but I suppose it is better than a complete error message!
=SUMIF('Costs 1'!$B$39:$B$44,NOT(B5:B23),'Costs 2'!$C$39:$C$44)
I have created a workbook and on my Totals worksheet I want the formula to look at a range of cells (C39:C44) on several worksheets(Costs 1 and Costs 2 for example). This range contains a list of suppliers.
Within this range if it finds a supplier name that does not appear in the main supplier list on my totals page (B5:B23), I want it to return the corresponding figure in the range C39:C44 on each of the worsheets and add them up. This figure will then give me the total spend with suppliers other than the core ones on my list.
Can anyone tell my why this isn't working, as there are definitely figures in the worksheets that the formula should be pulling through?
Thanks in advance.