Arfater Rahman
New Member
Hi,
I have a workbook that has around 100 worksheets.Each sheet has same format but different data for some specific companies.What I want to do to sum up a value for a specific company from all sheets of the workbook. I have attached a sample spreadsheet for your convenience.
In the sample spreadsheet -- you can see There are three sheets (Table1,.2,3) and Summary worksheet. In the summary sheet I have put a company name --comcast -- which is already in the other three sheets(Table1, Table2 etc) and have corresponding Total cable subs in the column B.I want to sum all this value for the company --comcast .
N.B :Ultimate value for comcast in the summary Tab will be = 329794.
Can anyone help me ? . It would very much appreciated.
I have a workbook that has around 100 worksheets.Each sheet has same format but different data for some specific companies.What I want to do to sum up a value for a specific company from all sheets of the workbook. I have attached a sample spreadsheet for your convenience.
In the sample spreadsheet -- you can see There are three sheets (Table1,.2,3) and Summary worksheet. In the summary sheet I have put a company name --comcast -- which is already in the other three sheets(Table1, Table2 etc) and have corresponding Total cable subs in the column B.I want to sum all this value for the company --comcast .
N.B :Ultimate value for comcast in the summary Tab will be = 329794.
Can anyone help me ? . It would very much appreciated.
