PC Review


Reply
Thread Tools Rate Thread

Average Error

 
 
Laytonius
Guest
Posts: n/a
 
      30th Sep 2009
I am trying to average the values in two columns. This would be an average
for each row. I understand it is typical to get a #DIV/0! error if one of
the columns has a zero in it but it is giving me the #DIV/0! error even
without a zero or null value in every row.
 
Reply With Quote
 
 
 
 
Jerry W. Lewis
Guest
Posts: n/a
 
      7th Oct 2009
Change the function from AVERAGE to COUNT. If you get 0, then your cells
contain text that only look like numbers, and hence are ignored by AVERAGE.

Jerry

"Laytonius" wrote:

> I am trying to average the values in two columns. This would be an average
> for each row. I understand it is typical to get a #DIV/0! error if one of
> the columns has a zero in it but it is giving me the #DIV/0! error even
> without a zero or null value in every row.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average ERROR Ed Davis Microsoft Excel Discussion 7 7th Sep 2008 07:38 PM
average with error tryn2learn Microsoft Excel Misc 7 29th Feb 2008 07:26 PM
Average Error =?Utf-8?B?dGFtaWx1Y2hp?= Microsoft Excel Worksheet Functions 2 26th Sep 2006 08:23 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Microsoft Excel Worksheet Functions 13 31st Jul 2005 03:59 PM
AVERAGE SQL error... help please Steven Microsoft ASP .NET 1 16th Oct 2003 02:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:21 AM.