Hi,
Required a formula help to return and sum a values of each lookup criteria wise in a summary sheet as per data available in daily sheet. Return a total hours as criteria lookup of (Codes:-C3:G3) and (items:-B5:B17) and (Total Hrs:-C5) in summary sheet range area C5:G17.
For your reference expected results are enclosed in the sample sheet.(Code wise sum values)
THANKS FOR THE HELP
Bookmarks