Countifs in Excel 2013

[bvanscoy678]

Hello,


I should know how to do this, but I am coming up blank. I attempted to do in a pivot table, but thought a formula would be better.


I have a list of employees that work each day. An employee maybe listed more than once during the day if he/she was split into another work area. I can easily sum their hours by their job title, but what I want to know is how many of each job title are working each day.


I hope my example explains a little better. I used 1 day as an example, but I will have several months in my actual work.


Thanks,

Brent


https://www.dropbox.com/s/mprwtanait7tdyf/countif%20question.xlsx

 

[bvanscoy678]

I was able to solve my problem with a helper column with some help. Thanks

 

[bobhc]

Good day bvanscoy678


Pivot table does the job and allows you to work with your data


https://dl.dropboxusercontent.com/u/75495784/bvanscoy678.xlsx

 

[Faseeh]

@ bvanscoy678 & bobhc,


I think we can also use subtotals but Pivot table is the quickest one.


Regards,