Auto sum

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3162222%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EAuto%20sum%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3162222%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EAuto%20sum%20I%20have%20to%20put%20the%20data%20from%2012%20data%20tabs%20into%20one%20final%20sheet%20so%20I%20have%20all%20the%20data%20from%20the%2012%20sheets%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3162222%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Auto sum I have to put the data from 12 data tabs into one final sheet so I have all the data from the 12 sheets 

2 Replies

You can use the Data consolidation

All your tabs must be identical(same columns and rows  order), on the tab you want to get the totals, click on Data --> from the Data tools group --> consolidate 

from the window that will appear add all your tab.

 

 

Thanks I will try it