Hellow everyone. Sorry if this has been answered already but I cannot find it. I am trying to create a formula that will search for employee numbers and add their sales value and spent values and report it on a seperate sheet which will contain a summary of all employees. So the formula would find all references to employee 1234 add their sales and spent columns and report "1234 Sales=1,500 and Spent=700.00". Thanks for your help.
|2||1100||1 Jan 13||1234||1,000.00||500.00|
|3||1200||1 Jan 13||5678||800.00||300.00|
|4||0900||2 jan 13||1234||500.00||200.00|
|5||1400||2 Jan 13||5678||200.00||100.00|