Good explanation of SUMIF, and some alternatives, he
http://www.xldynamic.com/source/xld....DUCT.html#2007

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"JKVA" wrote:

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.