Question about Sum of cells

[dyounger]

I have an employee time sheet that has multiple worksheets for every day of the week (Mon-Sat). I often have over 20 different employees on the sheet and the employees are not always the same each day on the sheet. I am trying to figure out how I can add the total hours an employee has worked on my job each week. Is there a formula that can :

1. Find Employee 's hours on each work sheet(Even if it is entered in a different cell on each work sheet)
2. Return the total hours of Employee A


I am not sure if Excel is capable of this, but I am sure someone out there does!

Thanks ahead of time

 

[norulen]

Would like to see sample input and output data to understand your exact requirement before suggesting you anything

 

[dyounger]

Would like to see sample input and output data to understand your exact requirement before suggesting you anything

Is there a way to attach a sample of my spreadsheet?

 

[Aladin Akyurek]

I have an employee time sheet that has multiple worksheets for every day of the week (Mon-Sat). I often have over 20 different employees on the sheet and the employees are not always the same each day on the sheet. I am trying to figure out how I can add the total hours an employee has worked on my job each week. Is there a formula that can :

1. Find Employee 's hours on each work sheet(Even if it is entered in a different cell on each work sheet)
2. Return the total hours of Employee A


I am not sure if Excel is capable of this, but I am sure someone out there does!

Thanks ahead of time

You could try to adapt Post #2 from...

http://www.mrexcel.com/forum/excel-questions/119020-sumif-multiple-sheets.html

to your lay-out.

 

[norulen]

You can try some external website to upload the file and provide the link here

Is there a way to attach a sample of my spreadsheet?