3d formulas

Hi Hoping someone can help, I need to gather data from multiple worksheets on multiple workbooks The below gives me #REF error =SUMPRODUCT(INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!'""'c$12:c$25"),$C$9:$C$22,INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!J$12:J$25")) Cell C5 refers to tab...

Hello, When I create the 3D formula it works beautifully if the other worksheets have data. If the sheets are left blank to create a template, it shows a result of 0. I would like it blank and NO zeros. =SUM('Sunday 9-30:Saturday 10-13'!E9) I thank you for your continued support. Elaine

I have been tasked with creating a large workbook to track productivity for a department across all of the weekday for the year. It must also include a sheet for the year-to-date average production for each member of the department. The way this was done last year by using a new worksheet...

Hi All - I'm working with a workbook that has 20 spreadsheets (tabs) and I want to search all 20 and extract a given text that is in 1 cell in each spreadsheet if the critera is met. I'm using the below formula to extract and sum (24hr) time in all 20 sheets, but I can't seem to modify it to...

Hi all, I have a budget workbook with 40 tabs, each laid out identically. Column A list the type of expense (rent, salaries, etc), and column B has the total expenses for the year. I want to have a new tab set up to summarize the data by tab. So Column a wolud be the same, column B would...