Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Average Function Help Needed Please! - MoodTool-1.xls (1/1)
I am doing a workbook for my patients. I have attached it here for
anyone that cares to look at it. I have a series of symptoms down the left hand side and a date range across the top. I have averaged response by symptom by the days in the month the patient places a numerical value in the cell, and averaged all symptoms responded to with a numerical value by day. What is stumping me is how to average all of the daily averages. What I want to end up with is a running average by symptom, a daily average of all symptoms, and a monthly average of all daily averages. What is the formula. Notice the ORANGE box. This is where I want the last calculation to go. I have tried =AVERAGE(B35:AF35), and =AVERAGE(AG5:AG34) with no luck. It does place the function in the cell, but when I start inputing numerical values in the cells, it auto averages symptom by month, and all symptoms by day, but nothing appears in the cell for the monthly average except the ## sign for the function! I understand that Excel auto rounds out based on the width of the cell, so I opened up the cell wider to see if that is the problem, but it is not. Does this require a different formula, because I am averaging a series of averages. I thought I could just choose a range of any cells and it would average it??? Can anyone help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average less MIN formula help needed | Excel Discussion (Misc queries) | |||
Average Function Help Needed | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Is there an AVERAGE IF function in Excel? | Excel Worksheet Functions | |||
Excel Function lessons Needed! | Excel Worksheet Functions |