Hello

Wondering if anyone can help me come up with a formula. Basically I want a single cell to search a worksheet for different information and spit out the total sum of that corrosponding "number". I attemted a consolidate and a sumif but it won't look for the multiple values that im after.

Basically I have a table of budgetary costs broken down into sub sections - however the report that I run breaks these down even further into individual codings. I want to be able to search for codes 5111000, 5113100,515000 etc and have it return the sum amount of all those codes into the table ive created that just has the sub section (summarises the costs). As there is multiple users and it is a copy and paste excercise the data will not be in the exact same corrosponding line every time - i.e code 5111000 could be in cell 1 on sheet 1 but on A48 on Sheet to - I need it to search that whole section for the correct number and then the amount in the cell next to it.

I hope this is making sense!! Been looking for something that can do this and unfortunately I can't write macros!!

Thanks - Chrissy