Hi all,

I am trying to sum Prod_Times (Col 5) in a particular column, which
correspond to each Company (Col 1) having similar or multiple
Tasks(Col 2).

As the data lies in multiple workbooks, i.e. for each month March,
April, etc...& all the data has to be collated into a single sheet
called Database, to make a sort of database, i need to have a VBA
looping structure order to add the Prod_Times for each Company with
only Similar Tasks.
The result should be shown in a separate sheet called Totals.

E.g:

Database Sheet:
CompanyName Tasks ...... Prod_Times
----------------------------------------------------------------------
Company1 Task1 01:00:12
Company1 Task1 00:20:42
Company1 Task2 03:03:32
Company2 Task11 01:10:12
Company2 Task21 01:30:12
Company2 Task11 04:00:12
Company3 Task10 01:00:32
Company3 Task10 02:11:44
Company3 Task10 01:20:12

I have already sorted the Database sheet.

Please advice.

Looks like this would be tailor made for a pivot table (under the data menu).
If not the final product, it could at least do the summarization for you.

--
Regards,
Tom Ogilvy


"noname" wrote:

Hi all,

I am trying to sum Prod_Times (Col 5) in a particular column, which
correspond to each Company (Col 1) having similar or multiple
Tasks(Col 2).

As the data lies in multiple workbooks, i.e. for each month March,
April, etc...& all the data has to be collated into a single sheet
called Database, to make a sort of database, i need to have a VBA
looping structure order to add the Prod_Times for each Company with
only Similar Tasks.
The result should be shown in a separate sheet called Totals.

E.g:

Database Sheet:
CompanyName Tasks ...... Prod_Times
----------------------------------------------------------------------
Company1 Task1 01:00:12
Company1 Task1 00:20:42
Company1 Task2 03:03:32
Company2 Task11 01:10:12
Company2 Task21 01:30:12
Company2 Task11 04:00:12
Company3 Task10 01:00:32
Company3 Task10 02:11:44
Company3 Task10 01:20:12

I have already sorted the Database sheet.

Please advice.