Excel - Multiplication/Division Q

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
32
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
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,114,032
Messages
5,545,628
Members
410,696
Latest member
JTrehan
Top