Time Sheet and Project hours analysis - urgent!!

Hi All,

I am a basic user of excel. I have setup a monthly time sheet for myself. Where i can tabulate hours against projects. I have also allowed for a drop down for the projects. However i would want all the hours i spend on my projects during different days in a week to be tabulated against that particular project on the project record list. This is important as i need to know how i am tracking. I could do it manually but it will be very tiresome so was wondering if someone could help me arrive at a formula/function. Please find attached my sample time sheet. Look forward to a quick response. Many Thanks in advance. Monika

I'm not 100% sure what you're trying to do, but I think you could use the sumif formula here. Add a total column on your April tab, and then on your project numbers tab in the April cell, do =SUMIF('Monika - Time Sheet April'!$A$3:$A$25,$A4,'Monika - Time Sheet April'!$AG$3:$AG$25)

Hi All,

Thank you for the real quick response. I tried the =IFERROR(SUM(INDIRECT(B$1&"!B"&MATCH($A2,April!$A$3:$A$25,0)+2&":I"&MATCH($A2,April!$A$3:$A$25,0)+"2")),"").
However, you will notice, as in the attached work sheet, only the first two weeks of hours spent on a particular project are calculated. However, it does not take into account the entire month.
Not sure why. I have attached the file for your reference.

Regards & Many Thanks,

Monika

Many Many Thanks. It works perfectly. Thanks all for your help...awesome... !!!!

Thanks for trying :-) Scott...