Consolidate quickly sums in Excel

See training on Trainer Lori channel!

If you need to sum totals from several worksheets, try consolidate which does all the calculations for you! 1) Use the same headings on each data worksheet 2) In a new sheet, click in A1 3) Click Data, Consolidate 4) Choose Sum to add the totals 5) Add each of the data sheets 6) Click OK Consolidate will organize and sum all the sheets!