Need to consolidate the data with an effective formula

Hi Richards,
Appreciate your quick response.I implemented this formula and hopefully its not showing any error but I am trying to understand here that How the overall capacity planning table should work and fetch the records from H&M table.
As we are fetching the result from E:E column of the overall capacity planning table and it is dependent on the H&M capacity plan table results.Please help that it should be merely a link to the values of the H&M tab or soe other formula needs to be implemented.Pls suggest

Regards,
aps

Hi,

Re #9. Not sure what you are getting at.

In E5 of the Consolidation you need to add 10 of the SUMIF formulae together changing the 2 character sheet name in each of the sumifs. Then copy down and across.

Obviously when you copy it to N5 and across you need to adjust the column ref from E:E to L:L because you have an additional two columns L&M on the Consolidation sheet which means a straight copy from E5 to N5 will be two colunmns adrift. Which is a good reason for keeping these sorts of things entirely consistent. i.e. your individual as, an.. sheets should have had exactly the same colunns as the Consolidation. You could have hidden them if necessary.