I need a formula to add up the sum of an employee

A

Amin

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
 
J

John C

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

Amin

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

John C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top