Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula to add up the sum of an employee
Hi i have a sheet for employees that capture weekly hrs for workers, after
four weeks i now want to use a function to sum all monies paid to each individual within the four weeks. but my sumif and sumifs dont seem to be helping. simply i want to see the total amount for an employee but wont want to add the up with sum function, but rather an advance formula. please help if there're any ideas thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula to add up the sum of an employee
We need little more information, i.e.: You say it's calculating hours, but
then you want to sum monies paid during the time frame, where is that determined? Sample data and data structure would be good. -- John C "Amin" wrote: Hi i have a sheet for employees that capture weekly hrs for workers, after four weeks i now want to use a function to sum all monies paid to each individual within the four weeks. but my sumif and sumifs dont seem to be helping. simply i want to see the total amount for an employee but wont want to add the up with sum function, but rather an advance formula. please help if there're any ideas thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula to add up the sum of an employee
Hi thanks for the advice, well my sheet has a column for employee names, then
five columns for their entire week hours worked i.e. monday to friday and i have a column that adds up what they will be paid foe the hrs done. now that they have worked for four weeks i want to use a function to give me the total sum of each worker in a new column. eg i could use "SUMIF" to get the results for only one week but when i add the week2 to the formular it dont work properly. again i used "sUMIFS" and in this i only one range for the sum option but multiple criterea which works for the other weeks but the sum wont be added because its not given me that option. i wish i could copy paste you a sample of it or insert you a table like it. but i hope you may see what am thinking of. "John C" wrote: We need little more information, i.e.: You say it's calculating hours, but then you want to sum monies paid during the time frame, where is that determined? Sample data and data structure would be good. -- John C "Amin" wrote: Hi i have a sheet for employees that capture weekly hrs for workers, after four weeks i now want to use a function to sum all monies paid to each individual within the four weeks. but my sumif and sumifs dont seem to be helping. simply i want to see the total amount for an employee but wont want to add the up with sum function, but rather an advance formula. please help if there're any ideas thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula to add up the sum of an employee
Without seeing the data structure, it's difficult to wrap my mind around it.
I am assuming column A has the employee name (or some such), columns B-F contain hours for the week, column G contains how much to be paid for the week. I guess what I need to know is, where are the other 3 weeks, are they in later columns, are they on separate tabs, or are they lower down on the same spreadsheet. It sounds as if you might want to look at SUMPRODUCT formula. This can sum a column based on multiple criteria. For example: =SUMPRODUCT(--($A$2:$A$100=empname),--($B$2:$B$100="Week1"),--($C$2:$C$100<"Vacation"),($H$2:$H$100)) This states that if you have an employee name who worked in week1 and was not on vacation, to sum the values in column H. -- John C "Amin" wrote: Hi thanks for the advice, well my sheet has a column for employee names, then five columns for their entire week hours worked i.e. monday to friday and i have a column that adds up what they will be paid foe the hrs done. now that they have worked for four weeks i want to use a function to give me the total sum of each worker in a new column. eg i could use "SUMIF" to get the results for only one week but when i add the week2 to the formular it dont work properly. again i used "sUMIFS" and in this i only one range for the sum option but multiple criterea which works for the other weeks but the sum wont be added because its not given me that option. i wish i could copy paste you a sample of it or insert you a table like it. but i hope you may see what am thinking of. "John C" wrote: We need little more information, i.e.: You say it's calculating hours, but then you want to sum monies paid during the time frame, where is that determined? Sample data and data structure would be good. -- John C "Amin" wrote: Hi i have a sheet for employees that capture weekly hrs for workers, after four weeks i now want to use a function to sum all monies paid to each individual within the four weeks. but my sumif and sumifs dont seem to be helping. simply i want to see the total amount for an employee but wont want to add the up with sum function, but rather an advance formula. please help if there're any ideas thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
employee | Excel Discussion (Misc queries) | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) | |||
Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
Formula for YTD total of Vac. Hrs. used for spec. employee | Excel Worksheet Functions |