formulas

  • Thread starter Thread starter Kay
  • Start date Start date
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?
 
Hi Kay,

Try this formula:

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

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

Biff
 
Back
Top