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

asked by Trinity

10 years ago

708 views

0

0

2 answers

Try

=sum(C3:C9)/7

answered by bobpursley

0

0

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

answered by Damon

0

0

Ask a New Question or answer this question.

Question

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

2 answers

Try

=sum(C3:C9)/7

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

Ask a New Question or answer this question.

bobpursley · Answer

Try =sum(C3:C9)/7

Damon · Answer

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