cells

J

John

how do I add values of cells on multiple worksheets into
one particular cell on one sheet
 
H

Hiram Hackenbacker

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Newbie Help - IF Yes No Function 0
Cell data entering slow! 0
Crating User Form to Add Names 1
Excel does not accept text format! 0
External cell reference between two excel worksheets both in One Drive 0
Word macro that can call cells out of Excel for a find and replace 0
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top