.               Sales in Lukovit                                                                                                

.               Jan          Feb         Mar                                                                      

T-Shirt   116791    16908      144898                                                                 

Cap         30870      27914      32220                                                                   

Trousers               456682    460576    422675                                                                 

.                                                                                                                           

.                                                                                                                           

.               Sales in Montana                                                                                                             

.               Jan          Feb         Mar                                                                      

T-Shirt   2301        2000        2341                                                                     

Cap         1102        1285        1200                                                                     

Trousers               556          863          761                                                                       

.                                                                                                                           

.                                                                                                                            

.               Total  Sales                                                                                                        

.                                                                                                                           

.                                                                                                                           

.                                                                                                                           

.                                                                                                                           

.                                                                                                                           

Пример за Обединение на данни                                                                                                               

Изберете клетка A16                                                                                                                      

От меню Data -> Consolidate изпълнете добавяне на двете посочени области:                                                                                                                           

.                                                                                                                           

Consolidate!$A$2:$D$5                                                                                                                  

Consolidate!$A$9:$D$12