Pivot table

[MRMBrowning]

Say I have a pivot table with amounts in it, how can I automatically add one total to another cell, to add to that old amount ? So it would be adding to the previous amount.

 

[rakesh seebaruth]

To add a total to another cell, you can use a formula in the target cell. For example, if the pivot table is in cell range A1:B4, you can use the formula =SUM(A1:B4) in the target cell to add the total of the pivot table to the amount in the target cell. You can also use the AutoSum feature in Excel to quickly add the total of a range of cells to another cell.