Tuesday, January 12, 2016

yogi_Sum Up Hours Worked From Weekly Sheets by Customer And Project

Google Spreadsheet   Post  #2016
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-12-2016
post by: tybo611:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/JBj4h7AQuhk;context-place=mydiscussions
SUMPRODUCT/SUMIFS acorss multiple sheets
I'm trying to use the SUMPRODUCT along with SUMIFS to gather data for expended hours across multiple weekly timesheets.  However the formula is only looking at the first sheet, it will not continue through to each subsequent sheet. 
The weekly time sheets are filled out, then the Data tab would pull all that information to track the amount of hours used across the weeks to quickly display any time remaining.
If it could be updated to automatically fill in the Customer and project that would be ideal but that is not a problem currently.
Any help would be much appreciated.  I've attempted this with query as well but couldn't get the syntax correct.
Sample sheet below
https://docs.google.com/spreadsheets/d/11NDNZPrOPANcCl9601cJ0IVRnMSG47hkrBJS_RDRuLI/edit?usp=sharing
All information has been stripped down to non specific, so use of cells/ranges in formula is desired so that it can be quickly updated.
I can get this to work in excel, but for some reason it does not carry over to google sheets. From what I've read, I'm guessing it could have something to do with the array calculations but I'm not sure. 
---------------------------------------------------------------------------------------------