• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula in Excel

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...
 
Ramesh_vm


Have a look at the Sumifs() function

http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/


or Sumproduct()

http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
 
Back
Top