#### Sundance_Kid

##### New Member

- Joined
- Sep 2, 2017

- Messages
- 32

I seem to be having a brain freeze but I can't for the life of me work out the correct formula.

Cell A1 = 60

Cell B1 = 2

Cell C1 = 2

Cell D1 = 2

Cell E1 = 5

I am trying to divide Cell A1 by the other numbers combined.

So I need to add the range of Cells from B1 to D1 to get 6 and multiply it by Cell E1 to get 30.

Then divide Cell A1 by the 30.

My formula was = A1/Sum(B1:D1)*E1

But instead of getting the correct answer of 2, I am getting 50.

What am I doing wrong?

Thanks