Friday, August 2, 2013
Consolidate quickly sums in Excel
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!
Subscribe to:
Posts (Atom)