how do I add values of cells on multiple worksheets into one particular cell on one sheet
J John Jul 13, 2003 #1 how do I add values of cells on multiple worksheets into one particular cell on one sheet
H Hiram Hackenbacker Jul 13, 2003 #2 how do I add values of cells on multiple worksheets into one particular cell on one sheet Click to expand... Are the values in the multiple worksheets in the same relative position in each sheet OR are the values in various different locations?
how do I add values of cells on multiple worksheets into one particular cell on one sheet Click to expand... Are the values in the multiple worksheets in the same relative position in each sheet OR are the values in various different locations?
B Bob I Jul 14, 2003 #3 use "Sum" with the cell locations separated by commas Easiest way is to type in "=SUM(" and then click on the desired cell then the comma then locate and click on the next cell and the when you have them all close the parenths.
use "Sum" with the cell locations separated by commas Easiest way is to type in "=SUM(" and then click on the desired cell then the comma then locate and click on the next cell and the when you have them all close the parenths.
