Employee roster - keeping track of the # of associates in a specific work group

**jwhitgrove** · 05-09-2014, 08:01 AM

Hello all
I am a new poster
We have hundreds of employees divided into twenty or so work groups. I use an Excel spread sheet to keep track of where everybody is currently assigned. My question deals with keeping track of the actual number of people per sub group. If we have 10 people in a group, I want to see this in a subtotal. I currently have assigne a value of 1 to each person. These add up in their own column. This works but feels so clunky. Is there a way to have Excel recognize that twenty entries = a value of twenty?

Thanks,
Jeff

**Kaper** · 05-09-2014, 08:18 AM

Yes, probably you can do this with SUMIF (or SUMIFS) function.

PS. after http://www.excelforum.com/forum-rule...rum-rules.html : Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.