LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default How to calculate with #div/0! error?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting and error while calculate business hours between 2 dates with holidays. [email protected] Excel Worksheet Functions 4 April 17th 07 08:08 PM
Calculate and display standard error harrynatick Charts and Charting in Excel 1 April 20th 06 09:18 AM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 2 March 31st 06 05:11 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 1 March 31st 06 04:24 AM
calculate average in percentage coloumn with #DIV/! (ignore error neelsels SA Excel Discussion (Misc queries) 2 September 6th 05 02:10 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"