Asked by Trinity
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!!
Answers
Answered by
bobpursley
Try
=sum(C3:C9)/7
=sum(C3:C9)/7
Answered by
Damon
I just tried
=sum(C3:C9)/7
and it worked
=sum(C3:C9)/7
and it worked
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.