simple formula

A

Ash T.

Cell A4 = A1 + B3
Cell B4 = D1 + E3
C4 = G1 + H3
And so on. How can I write the formulat in A4 so that I
can just drag that cell to cells B4, C4, D4 etc. so that
it'll use the correct intervals of the other two rows?

Can anyone help please
thanks
 
F

Frank Kabel

Hi
enter the following in A4
=OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3)
and copy down
 
A

ash

awesome,
Thank you so much

Ash
-----Original Message-----
Hi
enter the following in A4
=OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
A

Ash

Sorry but it doesn't work.
-----Original Message-----
Hi
enter the following in A4
=OFFSET($A$1,0,(ROW()-4)*3)+OFFSET($B$3,0,(ROW()-4)*3)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
F

Fred Smith

ash,

Remember that everyone posting to this newsgroup works for free. They are
very good at helping people, but you have to give them something to work
with. What didn't work? What message did you get? What result did you get
that was different from what you wanted?
 
A

Ash T.

Fred,
You sound like you are under the impression that I was
blaming or was critical of the group.
What gave you that impression? I'm not sure what is the
connection between referring that everyone posting works
for free. I have personnally thanked and expressed my
appreciation many many times to everyone here.
 
F

Frank Kabel

Hi
sorry my fault :)
I gave you a formula for dragging the formula down but not to the right
:)
Try the following in A4:
=OFFSET($A$1,0,(COLUMN()-1)*3)+OFFSET($B$3,0,(COLUMN()-1)*3)
 
F

Frank Kabel

Hi
I had no problem with your answer :)
But Fred mentioned one valid point: If a solution does not work it
helps if you provide some detail what EXACTLY does not work. In this
case not necessary as I just made a simple mistake :)
Solution: see my other posting
 
A

Ash T.

Frank,
Thank you very very much. I appreciate your help
enormously.
Now I can move on with this porject
Cheers
Ash
 
Top