I am trying to have calc summarize totals from pages (sheets) in the same .ODS file. I found a solution here:
However, since the format of the sheets and the output data is slightly different, I can not get the formula to work.
The formula used in the other solution
[ =SUMPRODUCT(SUMIFS(INDIRECT(""&$I$7:$I$10&"."&“D7:D33”),INDIRECT(""&$I$7:$I$10&"."&“C7:C33”),C7)) ] appears to use a list of page names. In an attempt to match that, I am using the “Employee Number” as the page name so I can reference that column from my “SUMMARY” as the sheet name.
Initially, I am trying to bring in the total hours from each timesheet (cell c49). But once I get past that stage, I would like to spread the time out to the codes listed in the SUMMARY (columns E-P on SUMMARY) from the individual time sheet code totals (C25 - C47 on timesheets). I realize that one of those sets of data is vertical and the other horizontal, however, that should be easily overcome by using individual formulas in the SUMMARY page.
My Sheet…
Timesheets-master.ods (33.6 KB)