Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averages | Excel Discussion (Misc queries) | |||
Help with Averages | Excel Worksheet Functions | |||
Averages | Excel Worksheet Functions | |||
Averages | Excel Worksheet Functions | |||
averages | Excel Worksheet Functions |