Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey there,
I'd like to get the average of a row filled with percentages. But because the percentages will only be filled in when the month has started I have some div/0! values. How can I calculate the average? And please try to keep it simple :D Hope I explained it clearly, if not let me know, see an example below. thx Nagje example (yes i know this isn't a row ;-) ): Jan 95.2% Feb 100.0% March 93.2% April 95.0% may 96.9% June 97.6% July #div/0! Aug #div/0! Sept #div/0! Okt #div/0! Nov #div/0! Dec #div/0! Average year = ??????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting and error while calculate business hours between 2 dates with holidays. | Excel Worksheet Functions | |||
Calculate and display standard error | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) |