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