Summarise data from multiple sheets with one condition


Assume there are ten worksheet tabs – one for each retail store.  Each worksheet tab has sale data of different brands across 12 months – brands are arranged in rows and months are arranged in columns.  The structure of all worksheets tabs is the same.  Furthermore, each store is managed in any of the two retail formats – Joint venture or Owned and Operated (O&O) by the company.

One may want to summarise data from the ten worksheets tabs for each brand across 12 months for a certain retail format.

You may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.


  • Great formula! Thanks.
    Just be sure that the sheet name doesn’t have spaces (I spent sometime figuring this out)