# Average Calculations

#### babypink2807

##### New Member
I am clearly doing something wrong, its so simple but for some reason it wont work lol

I have three columns

Time to site in hours

Minimum Maximum Average

1 2 =AVERAGE(B6:C6)
2 3 =AVERAGE(B7:C7)

But when I press the enter key it does not calculate it, it stil shows the formula, what on earth am I doing wrong?

I expect Average 1 to be 1.5hrs and Average 2 to be 2.5hrs

Argh!

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

##### Board Regular
When you go to the formulas tab, is the "Show Formulas" highlighted? Also is your Calculation options set to Automatic?

#### AlanY

##### Well-known Member
check if you have an extra space before the =

#### babypink2807

##### New Member
check if you have an extra space before the =

There

THere are no gaps or show formula. I am using the drop down menue to select AVERAGE and then a popup box appears and auto fills my cell range then I click ok, but it just will not work

#### 63falcondude

##### Well-known Member
Check the formatting of the formula cells. Maybe they are in text format. Change the format to general and reenter the formulas.

#### babypink2807

##### New Member
Check the formatting of the formula cells. Maybe they are in text format. Change the format to general and reenter the formulas.

When I do that I get #DIV/0!

#### 63falcondude

##### Well-known Member
When I do that I get #DIV/0!

My guess is that the numbers in the minimum and maximum columns are text values as well. To test this, change those columns to general and reenter the values.

#### anu_gv

##### Board Regular
When I do that I get #DIV/0!

May be the cell that you are pointing is correct.

#### AlanY

##### Well-known Member
could you share the file on google drive or similar?

Replies
1
Views
126
Replies
23
Views
344
Replies
3
Views
606
Replies
4
Views
264
Replies
2
Views
248

1,191,008
Messages
5,984,134
Members
439,872
Latest member
ExcelRM

### 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