Summarize companies production

I have excel 2010. An excel sheet that has many companies production during each day of the month. I need it to summarize automatically the names of the companies and their production. Is that possible please?

For example:

Company Arrival Departure Rooms 1-Apr 2-Apr 3-Apr 4-Apr 5-Apr 6-Apr 7-Apr 8-Apr 9-Apr 10-Apr
Abraam Tours 29-Mar 5-Apr 1 1 1 1 1            
Abraam Tours 12-Apr 19-Apr 1                    
Abraam Tours 12-Apr 19-Apr 1                    
Abraam Tours 29-Mar 4-Apr 1 1 1 1              
Abraam Tours 29-Mar 5-Apr 1 1 1 1 1            
Alliance Travel 24-Apr 30-Apr 1                    
Alliance Travel 2-Apr 16-Apr 1   1 1 1 1 1 1 1 1 1
Alliance Travel 20-Apr 30-Apr 1                    
American Express 1-Apr 3-Apr 1 1 1                
Anex Germany 18-Apr 22-Apr 1                    
Anex Germany 27-Apr 5-May 1                    
Anex Tour  Bright 30-Mar 11-Apr 1 1 1 1 1 1 1 1 1 1 1
Anex Tour  Bright 10-Apr 20-Apr 1                   1

By: elia

Leave a Reply

Your email address will not be published. Required fields are marked *