Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the AVERAGE Function
I have a spreadsheet listing the months of the year in A12:A23. In O12:O23,
I am capturing a QA rating for our call center. Cell O24 contains the following formula: =IF(SUM(O12:O23)<0,AVERAGE(O12:O23),"") which gives me the average QA rating for the year. My problem is that since we are only through the month of January, the total in O24 won't make sense until after I input every month's QA numbers. Is there a way to tweak this formula so that will give me an accurate QA average as the year progresses? -- Tia, Education and Documentation Specialist |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE function returns #DIV/0! error | Excel Discussion (Misc queries) | |||
Average function assistance | Excel Discussion (Misc queries) | |||
EXCEL 2000 AVERAGE function | Excel Worksheet Functions | |||
Using the average function | Excel Worksheet Functions | |||
How do I use an average function, not counting cells containing a | Excel Worksheet Functions |