formulas

K

Kay

I have entered the formula in sheet "A". I want to bring a
total of several cells from sheet "b". The page is not
adding the cells from page "b", instead it takes the cells
in page "A".
My formula looks like this. What am I doing wrong?
=+B!m12+o12+r12

Is there anyway to copy that formula and have the number
change by 2 digits each time?
 
B

Biff

Hi Kay,

Try this formula:

=SUM(B!M12,B!O12,B!R12)

The copy would work if you copy it two rows down.

Biff
 

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

Copy addition formula of non-consecutive horizontal cells 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Section and Page numbering 0
Is there a function to count how many times a cells value is used? 0
Hide columns based on row values 2
Getting a formula to reflect added columns 10
dragging formula is giving me undesired result in cell calls. 0
Cells not updated automatically 3

Top