SUMIF Formula

J

JKVA

Could someone help me to create a SUMIF formula in Excel 2003 that sums the
employees working at a certain time (i.e. 1500, 1700, 1900)? Each row would
have the employee's time in and time out and the columns would show each day
of the month. If an employee is working that day, there's a "1". The
employees always work the same hours.
Thank You.
 
F

Fred Smith

It would look something like this:
=sumproduct(--(a1:a100="Fred
Smith"),--(b1:b100=1),--(c1:c100<=time(15,0,0)),--(d1:d100)>=time(15,0,0))
Adjust the ranges to suit.

Regards,
Fred.
 
J

JKVA

Very interesting. What if I'm not concerned with the employee name? I'm
basically trying to get a count of all employees working at certain time
periods at the bottom of the spreadsheet for each day of the month. I would
want to count the employees that are working on each day of the month at
0700, 1100, 1730, and 1930. Please let me know if I can give you more info.
Thanks for your help.
 
J

JKVA

Very interesting.
What if I'm not concerned with employee name. I'm just trying to get a
count of how many employees are working at specific time periods (0700, 0900,
1100, 1730, and 1930) based on their time in/time out. I would want to
display this count at the bottom of the spreadsheet under each day of the
month.
Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top