Formula Assistance

[Russ At Index]

Afternoon Everyone ,

I have a little problem that i am hoping can be resolved by the XL experts ...

In cell F2 , =(C2-1)*E2

I would like to include the sum of D2:F2 into the same formula .

Can someone point me in the right direction ?.

Many thanks ,

Russ.

 

[Saurabhj]

Hi,

Please check if this solves:

=(C2-1)*E2 +SUM(D2:F2)

 

[Rahul1987]

Afternoon Everyone ,

I have a little problem that i am hoping can be resolved by the XL experts ...

In cell F2 , =(C2-1)*E2

I would like to include the sum of D2:F2 into the same formula .

Can someone point me in the right direction ?.

Many thanks ,

Russ.

What about?

Book1
	C	D	E	F
1	A	B	C	D
2	5	25	55	3
3	Output
4	303
Sheet1

Cell Formulas
Range	Formula
C4	C4	=((C2-1)*E2)+(SUM(D2:F2))

 

[Fluff]

If this formula

=(C2-1)*E2

is in F2 then you cannot include the sum of D2:F2 otherwise you will get a circular reference.

Can you post some sample data explaining what you are trying to do.

 

[Russ At Index]

Hi All,

Solution has been reached , thank you all so much , Saurabhj your little "gem" did the trick.

Thanks again for helping me out ,

Stay safe all,

Russ.

​