Average Calculations

[babypink2807]

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!

 

[Big Wade]

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

 

[AlanY]

check if you have an extra space before the =

 

[babypink2807]

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]

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

 

[babypink2807]

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]

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]

When I do that I get #DIV/0!

May be the cell that you are pointing is correct.

 

[AlanY]

could you share the file on google drive or similar?