Adding point value from cell X to each value in a range e1:e10 in an equation

[joshnathan]

Hello All,
I want to add a value from cell X to every value listed between E2:E40 w/e in the actually equation so my cell values for E dont change.
This is the equation: =(I1^2 - SUMPRODUCT(E5:E54^2*$G$5:$G$54^2)) / (2*SUMPRODUCT($G$5:$G$54 * TRANSPOSE($G$5:$G$54) * E5:E54 * TRANSPOSE(E5:E54) * (TRANSPOSE($P$5:$P$54) > $P$5:$P$54)))
whats the best way of going about this so it doesn't affect the rest of the sum?

[npamcpp]

What does "w/e" mean?

Can you post a workbook with a "before" and "after" scenario? Put the desired results in manually and describe the logic in words.

[jason.b75]

The question doesn't make much sense so the answer is a guess at what I think it means.

=(I1^2-SUMPRODUCT((E5:E54+J1)^2*$G$5:$G$54^2))/(2*SUMPRODUCT($G$5:$G$54*TRANSPOSE($G$5:$G$54)*(E5:E54+J1)*TRANSPOSE(E5:E54+J1)*(TRANSPOSE($P$5:$P$54)>$P$5:$P$54)))

Cell X could be anything so I've used J1 in the formula.

[joshnathan]

Thats what i wanted sorry for not making to much sense i just wanted to confirm that the simple + Acell was all i needed.

[Cutter]

@joshnathan
Based on your last post I'll mark this thread as SOLVED. Please keep in mind for your future threads that the forum rules require you to do this yourself. Thanks.

Here's the method:

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

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