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 |
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 |