In Excel 2003 I want to add the total number of surveys conducted per supervisor if my data in excel looks like the following :
Supervisor Employ Survey Total
shane mike A 5
shane mike B 4
chris mike C 2
What i need is to find out the total number of surveys conducted per supervisors. I have tried to use a several type of variations of arrays and vlookups but could not get it. please tell me how can i add column of numbers with condition specified above.
Bookmarks