Formula too large

[Cindyt]

I have 15 separate workbooks with 60 different items that I am combining into
a total spread sheet. I'm already getting the "Formula too large" error and
I will need to be expanding on these original 15 workbooks in the future. Is
there anything I can do without breaking these down into groups and then
totaling?

Thanks

 

[Don Guillett]

Might be nice to give us some detail

 

[Cindyt]

Workbooks for each employee: John, Mary, Sally, etc

in each workbook, there's a tab for each month of year

on each worksheet, there are lines for Endorsements, Audits, Renewals,
Cancellations, etc. and these are counted by weeks, so for July there are 5
columns for each.

When I add them into the Totals workbook, the worksheets are by month and
they are set up like the ones above - by week.

Does that help? I know this is elementary - but still need help. Thanks
for anything you can suggest.

 

[Abnerz]

assuming all tabs are identical, add a tab at the start and call it start.
Add a tab at the end and call it end.

on yoyr summary sheet (before the start tab), use this formula.

SUM(Start:End!S18)

Replace S18 with proper cell.

Hope this helps

 

[Don Guillett]

This probably??? could be all ONE workbook and perhaps even one worksheet
using data>filter>autofilter to get data for each person and/or month, as
needed. However, if you insist on keeping as is it would be necessary to see
the main workbook and at least one of the employees workbooks. Send to my
address below WITH a copy of this message and a COMPLETE explanation and
before/after examples.