# Formula ? to get an average

#### zone709

##### Well-known Member
=(+B115+C115)/E115

this is returning 0.01 when it should be \$78.81. What am I missing on this formula. I am adding 2 total hours divided by the Total \$ amount?

Thanks

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### husoi

##### Board Regular
Zone,

why don't you use AVERAGE() formula? in my opinion would make more sense. I tried your formula and works as long you add the correct values. You don't need the plus sign before B115 and if the average is only 2 numbers you can replace E115 buy 2
=(B115+C115)/2
AVERAGE(B115,C115,...)

#### zone709

##### Well-known Member
ok but E115 is total amount like \$73,980 divided into B115 + C115

#### Tetra201

##### MrExcel MVP
To get \$78.81, you need to divide \$73,980 by something, not the other way around.

So, I guess the formula should be =E115/(+B115+C115)

#### zone709

##### Well-known Member
ok maybe I have it backwards ill try this thanks

#### zone709

##### Well-known Member
Still returning wrong amount. Cant figure out why.

Example:
Adding B289 AND C289 Divided into \$91,26508 E289

Excel 2016 (Windows) 32 bit
B
C
D
E
289
704
172.5
0
\$ 91,265.08
<strike></strike>

#### Tetra201

##### MrExcel MVP
Still returning wrong amount. Cant figure out why.

Example:
Adding B289 AND C289 Divided into \$91,26508 E289

Excel 2016 (Windows) 32 bit
B
C
D
E
289
704
172.5
0
\$ 91,265.08

<tbody>
</tbody>

<tbody>
</tbody>
<strike></strike>
=E289/(B289+C289) returns \$104.12

#### zone709

##### Well-known Member
its good thanks this is working now. Thanks everyone for the help

#### Tetra201

##### MrExcel MVP
You are welcome. Glad you got what you needed.

Replies
2
Views
137
Replies
3
Views
2K
Replies
2
Views
111
Replies
7
Views
216
Replies
5
Views
132

1,191,282
Messages
5,985,740
Members
439,978
Latest member
Mr930R

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back