sangeeta25
Board Regular
- Joined
- Jun 15, 2015
- Messages
- 59
Hi
I have never really used V look up before and correct me if I'm wrong but I think v look up is what I will be needing to use to fulfil my request below:
I have a document which lists staff members who have completed their training or started their training. Now in an excel document, the first sheet called table has a table where column A lists the departments within the business, column B has the total number of staff, i.e. in each department, column C has the total number of staff who completed their training, i.e. in that department, and column D has the total number of staff who have started their training, i.e. in that department.
Sheet 2 is called HR, sheet 3 is called Finance and sheet 4 is called Legal. So within each of these sheets has data of the staff in that department, including column H which says if they have "Completed" or "Started" their training and Column A which has the name of that staff member.
What I would like to do, is be able to have the table in sheet 1 populated according to the data in sheets 2, 3 and 4.
So for instance what formula do I put in cell B3 (in the table on sheet one) which will give me the total number of staff in the HR department (sheet 2 has a list of names etc of the staff in the HR department) and what formula do I use in cell C3 which will give me the number of staff in the HR department who have "Completed" their training (it says if that staff member in HR has "completed" or "started" their training in sheet 2, column H)
Can someone please assist?
Much appreciated.
S
I have never really used V look up before and correct me if I'm wrong but I think v look up is what I will be needing to use to fulfil my request below:
I have a document which lists staff members who have completed their training or started their training. Now in an excel document, the first sheet called table has a table where column A lists the departments within the business, column B has the total number of staff, i.e. in each department, column C has the total number of staff who completed their training, i.e. in that department, and column D has the total number of staff who have started their training, i.e. in that department.
Sheet 2 is called HR, sheet 3 is called Finance and sheet 4 is called Legal. So within each of these sheets has data of the staff in that department, including column H which says if they have "Completed" or "Started" their training and Column A which has the name of that staff member.
What I would like to do, is be able to have the table in sheet 1 populated according to the data in sheets 2, 3 and 4.
So for instance what formula do I put in cell B3 (in the table on sheet one) which will give me the total number of staff in the HR department (sheet 2 has a list of names etc of the staff in the HR department) and what formula do I use in cell C3 which will give me the number of staff in the HR department who have "Completed" their training (it says if that staff member in HR has "completed" or "started" their training in sheet 2, column H)
Can someone please assist?
Much appreciated.
S
