#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Averages

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7, mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????



  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Averages

I tried that, it doesn't work. It's still not including the 0s

"Bob Phillips" wrote:

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7, mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,420
Default Averages

It does if they are real zeroes.

--
__________________________________
HTH

Bob

"Paige06" wrote in message
...
I tried that, it doesn't work. It's still not including the 0s

"Bob Phillips" wrote:

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them
in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7,
mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????






  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Averages

and I forgot to mention I need to skip one column

"Bob Phillips" wrote:

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7, mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Averages

In which case, specify ranges which don't include that column.
--
David Biddulph

"Paige06" wrote in message
...
and I forgot to mention I need to skip one column

"Bob Phillips" wrote:

=AVERAGE(B38:M38)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Paige06" wrote in message
...
I need to average a row some cells have 0's but I need to include them
in
the function so it averages correctly. The formula I currently have is
this
=AVERAGE(IF(B38:M38<0,B38:M38,"")). It is working with the cells with
numbers, but not the cells that do not. Example : jan - 5, feb - 7,
mar.
0,
april - 18 = 30 divided by 4 = 7.50. My sheet will only calulate 3. Any
suggestions?????








Reply
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
Averages Marvin Excel Discussion (Misc queries) 5 July 4th 08 09:34 AM
Help with Averages TimJames Excel Worksheet Functions 2 March 6th 08 08:53 PM
Averages Bec[_3_] Excel Worksheet Functions 3 September 12th 07 05:20 AM
Averages Beth Excel Worksheet Functions 4 March 9th 06 08:19 PM
averages mpmike1993 Excel Worksheet Functions 0 February 16th 06 09:31 PM


All times are GMT +1. The time now is 07:13 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"