in excel how do you total 1 cell on 25 different tabs?
J John Bundy Mar 7, 2008 #3 If the data is in the same cell on every sheet, then where you want the total type =sum( then shift and click the last sheet, this will select on in that range, then click the cell that contains the data, then add a ) and hit enter.
If the data is in the same cell on every sheet, then where you want the total type =sum( then shift and click the last sheet, this will select on in that range, then click the cell that contains the data, then add a ) and hit enter.