Simple Excel Formula

[RPADC]

Hello

I have a problem with Excel. I want Excel to continue the following formula:

A1+B1
A1+B2
A1+B3
A1+B4
etc...

However Excel keeps replacing the formula into:

A1+B1
A2+B2
A3+B3
A4+B4
etc..

I'm sure there must be a sollution for this, however I have no idea how to fix it...

Is there someone who can help me with this formula

[hermithead]

Use the $ signs and it will fix the cell ref

$A$1+B1
$A$1+B2
$A$1+B3
$A$1+B4

[RPADC]

Wauw You're brilliant!!

Thank you very very much!

[zbor]

1. Your title doesn't comply rules
2. If you get your answer please make thread solved

[mudraker]

RPADC

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

=============================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save