Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
Hi there, I was wondering if anyone could help me.
The formula I am using is adding all entries for each employee. Instead of adding the number of days I would like to do a count. =SUMIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6,'Sick Leave'!$H$6:$H$43618) Worksheet 'Sick Leave' has all the data Worksheet 'Employee List' is where I would like to return a count and not the total days per employee. The formula is looking up the employee's name from the sick leave worksheet in Column A and then looking in Column H and returning a total. I would like it to return a count. Worksheet 'Sick Leave' has the number of days each employee is off on sick leave, somethimes the entry could be .50 of a day for 10 days and the result will be a total of 5 days. I want to be able to count the number of times the employee is absent from work, if the employee is a .50 and off for 10 days it will return a sum of 5 days and I would like to see a count of 10. I hope someone understands what I am trying to explain? Thanks. -- Newfie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
=COUNTIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6) ?
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Newfie809" wrote: Hi there, I was wondering if anyone could help me. The formula I am using is adding all entries for each employee. Instead of adding the number of days I would like to do a count. =SUMIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6,'Sick Leave'!$H$6:$H$43618) Worksheet 'Sick Leave' has all the data Worksheet 'Employee List' is where I would like to return a count and not the total days per employee. The formula is looking up the employee's name from the sick leave worksheet in Column A and then looking in Column H and returning a total. I would like it to return a count. Worksheet 'Sick Leave' has the number of days each employee is off on sick leave, somethimes the entry could be .50 of a day for 10 days and the result will be a total of 5 days. I want to be able to count the number of times the employee is absent from work, if the employee is a .50 and off for 10 days it will return a sum of 5 days and I would like to see a count of 10. I hope someone understands what I am trying to explain? Thanks. -- Newfie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
Hi Max, I tried that one also and it returns a grand total of the count
forall employees and not for each employee thanks. -- Newfie "Max" wrote: =COUNTIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6) ? -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Newfie809" wrote: Hi there, I was wondering if anyone could help me. The formula I am using is adding all entries for each employee. Instead of adding the number of days I would like to do a count. =SUMIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6,'Sick Leave'!$H$6:$H$43618) Worksheet 'Sick Leave' has all the data Worksheet 'Employee List' is where I would like to return a count and not the total days per employee. The formula is looking up the employee's name from the sick leave worksheet in Column A and then looking in Column H and returning a total. I would like it to return a count. Worksheet 'Sick Leave' has the number of days each employee is off on sick leave, somethimes the entry could be .50 of a day for 10 days and the result will be a total of 5 days. I want to be able to count the number of times the employee is absent from work, if the employee is a .50 and off for 10 days it will return a sum of 5 days and I would like to see a count of 10. I hope someone understands what I am trying to explain? Thanks. -- Newfie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
"Newfie809" wrote:
Hi Max, I tried that one also and it returns a grand total of the count for all employees and not for each employee It should not. I'm not sure what's happening over there =COUNTIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6) ? should return the count of the number of instances that the particular employee, ie 'Employee List'!B6, appears within 'Sick Leave'!$A$6:$A$43618 Check/try again? -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
Hi Max,
I tried it again and it worked, thank you. -- Newfie "Max" wrote: "Newfie809" wrote: Hi Max, I tried that one also and it returns a grand total of the count for all employees and not for each employee It should not. I'm not sure what's happening over there =COUNTIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6) ? should return the count of the number of instances that the particular employee, ie 'Employee List'!B6, appears within 'Sick Leave'!$A$6:$A$43618 Check/try again? -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Counta
Good to hear. Pl take a moment to click the YES button (like the one below)
in that response. Thanks. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Newfie809" wrote: Hi Max, I tried it again and it worked, thank you. -- Newfie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to look up a =COUNTA and =SUM formula from another sheet? | Excel Discussion (Misc queries) | |||
Counta formula | Excel Discussion (Misc queries) | |||
COUNTA for a cell with a formula | Excel Worksheet Functions | |||
COUNTA Formula not working | New Users to Excel | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |