# Excel - Multiplication/Division Q

#### Sundance_Kid

##### New Member
Hi Folks,

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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### hrayani

##### Well-known Member
Place brackets

=A1/(SUM(B1:D1)*E1)

Deleted

#### Yongle

##### Well-known Member
or ...
=A1/SUM(B1:D1)/E1

You are welcome

Replies
23
Views
1K
Replies
8
Views
112
Replies
8
Views
84
Replies
4
Views
55
Replies
3
Views
216