Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Time Sheet Reads as followed:
A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
=countif(c:c,"0")
"Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Mr, B
I get a total of 8. What is wrong? -- Thank you "bpeltzer" wrote: =countif(c:c,"0") "Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Sorry, the hours worked is in column D, so it's countif(d:d,"0").
--Bruce "Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Mr, B
I do not want the hours worked. I want the total of the # of employees that worked for the day. I have 8 employees, but only 4 worked that day in column C. I need the formula to come up with 4 as the answer. -- Thank you "bpeltzer" wrote: Sorry, the hours worked is in column D, so it's countif(d:d,"0"). --Bruce "Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Okay, so it is column C. Then =countif(c:c,"0") should work if this table
is the only data in the column. If there's additional stuff above or below your table, then specify the row range as well: =countif(c4:c11,"0"). BTW, the equation you got for the hourly rate provided the answer you asked for; but you should be aware that it's NOT the average labor cost per hour worked if the employees' rates and hours worked differ from one another (as is the case in your example). --Bruce "Myrna" wrote: Mr, B I do not want the hours worked. I want the total of the # of employees that worked for the day. I have 8 employees, but only 4 worked that day in column C. I need the formula to come up with 4 as the answer. -- Thank you "bpeltzer" wrote: Sorry, the hours worked is in column D, so it's countif(d:d,"0"). --Bruce "Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Employee Rate %
Mr. B,
Thank you for your patience, yes I had data below. Specified my range and formula works. -- Thank you "bpeltzer" wrote: Okay, so it is column C. Then =countif(c:c,"0") should work if this table is the only data in the column. If there's additional stuff above or below your table, then specify the row range as well: =countif(c4:c11,"0"). BTW, the equation you got for the hourly rate provided the answer you asked for; but you should be aware that it's NOT the average labor cost per hour worked if the employees' rates and hours worked differ from one another (as is the case in your example). --Bruce "Myrna" wrote: Mr, B I do not want the hours worked. I want the total of the # of employees that worked for the day. I have 8 employees, but only 4 worked that day in column C. I need the formula to come up with 4 as the answer. -- Thank you "bpeltzer" wrote: Sorry, the hours worked is in column D, so it's countif(d:d,"0"). --Bruce "Myrna" wrote: Time Sheet Reads as followed: A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) | |||
subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Referencing a newly created worksheet | Excel Worksheet Functions |