# EXCEL 2010 (again)

posted by .

I am not allowed to use the AutoSum or AVERAGE functions to work out this problem. I need to find the average of a cell range. C3:C9 contains numbers (one cell contains zeros) the range adds up to 230. To find the average I need to use the information contained in column A range A3:A9 which are the days of the week totalling 7 days. I must use one cell range so I have use =C3:C9/7 and I get #VALUE! No matter which way I turn this formula around I get the same answer. What am I doing wrong? Can you help?FIRST RESPONSE WAS TRY =SUM(C3:C9)/7. This came back with the answer "TRUE". PLEASE CAN SOMEONE HELP!!

• EXCEL 2010 (again) -

Try

=sum(C3:C9)/7

• EXCEL 2010 (again) -

I just tried
=sum(C3:C9)/7
and it worked

## Similar Questions

1. ### math

Does anyone know how to explain mean, median, mode and range mean?
2. ### math

14.what value of n will result in a mean if 31 15.what value of n will result in a median of 23 15.what value of a will result in a range of 84 14,46,19,10,39,22,24,77,n Refresh your memory about the defnition of median, mode and range …
3. ### science

Assignment says label the parts of a plant cell. I'm blind so I'm going to write the names and put their functions. Cell wall, strenghthens the cell. vacuole is where the cell sap is produced. cell membrane is on outside on the cell. …
4. ### Algebra

23. The ___ axis represents the independent variable. X?
5. ### Math

If f(x)=sin(x) and g(x)=x^2-x+1, find the domain of f(g(x)) and g(f(x)). I was able to determine that: f(g(x))= sin(x^2-x+1) and g(f(x))= sin(x)^2 -sin(x) +1 Here is what I am thinking: the range of f(x) is (x e R) and the range of …
6. ### Excel formula help

Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
7. ### Excel

Values in a function: A. must be spelled out in words, not numbers B. must be entered as whole numbers. c. Can be a cell or a range of cells D. Cannot have a negative value.
8. ### technoligy

1. What function would you use to find the mean in a microsoft(R) excel document a=ROUND b=AVERAGE c=SUM d=HYPERLINK 2. What is the first thing you should do to find the mean and range of data?
9. ### Education and technology

1. What function would you use to find the mean in a microsoft(R) excel document a=ROUND b=AVERAGE c=SUM d=HYPERLINK 2. What is the first thing you should do to find the mean and range of data?
10. ### Technology

1. What function would you use to find the mean in a microsoft(R) excel document A. ROUND B. AVERAGE •• C. SUM D. HYPERLINK 2. What is the first thing you should do to find the mean and range of data?

More Similar Questions