Hello:
Please refer to attached excel file.
I have 2 sheets, Hours and Summary.
Hours sheet shows hours for employees listed in row 2 and date in column A.
I need a formula in Summary sheet in cell D4:D8 so that each employee hours are
calculated between date in cell C1 and C2.
Please refer to attached file.
Let me know if you have any questions.
Thanks.
Riz
in D4Formula:
Please Login or Register to view this content.
try this
Punnam
Slight variation on Punnam's suggestion...
=SUMIFS(OFFSET(Hours!$A$2,1,MATCH($A4,Hours!$B$2:$G$2,0),400,1), Hours!$A$3:$A$402,">="&Summary!$C$1, Hours!$A$3:$A$402,"<="&Summary!$C$2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Or this 1...
=SUMPRODUCT((Hours!$B$2:$G$2=Summary!$A4)*(Hours!$B$3:$G$367)*(Hours!$A$3:$A$367>=$C$1)*(Hours!$A$3:$A$367<=$C$2))
Hi FDibbins:
Like your formula and works great.
Thanks a lot.
Riz
Glad we could hel9, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks