Ramesh_vm
New Member
I have a 4 different Department in my office, and each department has 10 employees under them .So I want to use a formula that shows me the Total number of hours completed in Each department(consolidate of all 10 employees)for all 4 different department.
So I want to use the formula in C2 column(Hrs.of Training Completed) so that it can show me the consolidate of all 4 different:
Department Manager Hrs.of Training Completed Mandatory
Production Raghav 40
Control Rohan 40
Receipt Sandesh 40
Funds Rohini 40
pls help me in this...
So I want to use the formula in C2 column(Hrs.of Training Completed) so that it can show me the consolidate of all 4 different:
Department Manager Hrs.of Training Completed Mandatory
Production Raghav 40
Control Rohan 40
Receipt Sandesh 40
Funds Rohini 40
pls help me in this...