Contour Enthusiasts Group Archives Forums General Common Interests Ok Excel Pros ?? For ya

So I have created a schedule for my department at work, I have the boxes set up in a calendar format, with each members name in a box that corresponds with the shift. How can I get the program to add up all the shifts for the week?

Not a pro, but I know how to do what you're looking to accomplish.

Go to the bottom of the column you want totaled and on the menu bar above there should be a little "E" looking symbol. Click that and you can highlight the boxes you want totaled. Then hit enter. Or you can use a formula.

You want a count of the number of shifts each person works on the bottom?

You'll probably want to use the COUNTIF function. You can list the employees names on the bottom, and use the function to count the number of times that name shows up throughout the schedule.

I don't have Excel installed on this PC or I'd walk you through it. I need to walk through the steps myself to feel comfortable telling you how. The help file should help you out.

Clippy is yo' friend!

Highlight the area you want to run, click on Data - then Subtotals. You can subtotal by any of the multiple columns you have, in this case it sounds like individual departments or employee names. Check the individual columns you want to total (such as hours worked) and check the subtotals on bottom box and you can have a total all of these hours.

You can also use the subtotals formula to run the same 9 different functions including adding, averaging, counting, etc...


Good luck

The 'e' looking symbol is sigma. In excel it equates to 'auto sum'

simply highlight the cels in a column and add one more at the bottom. While the cells are highlighted, click on sigma. That last cell at the bottom will now have a total of the values of all the cells added together.

You can also work in rows and multiple columns or multiple rows.

Hope that helps.

Basically I have 10-12 employees, and 5 shifts per day, I need too keep a running track of how many hours each works per week. 6 day work week

if you email me the spreadsheet i can do it in like 5 mins...but i cant explain it well