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

Try

=sum(C3:C9)/7

I just tried

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

Yes, I can help you with that. It seems like you are trying to find the average of the numbers in the range C3:C9 using the total days in the range A3:A9.

To calculate the average of a cell range without using the AutoSum or AVERAGE functions, you can use the SUM function and divide the result by the total number of values.

In this case, you mentioned that the range C3:C9 adds up to 230 and A3:A9 contains the days of the week, which totals 7 days.

To get the average, you can use the formula: =SUM(C3:C9)/COUNT(C3:C9).

The COUNT function will count the number of values in the range C3:C9, excluding any blank cells.

So, the revised formula should be: =SUM(C3:C9)/COUNT(C3:C9).

Make sure you enter this formula in a different cell, not in the same range you are trying to average.