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.
A | B | C | D | E | |
1 | Time | Date | Employee | Sales | Spent |
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 |