Home |
Search |
Today's Posts |
#1
|
|||
|
|||
removing zeros from fromulas in excel
I'm using Excel and trying to do averaging using averaging in the formula
there are zero's with in the infomration that I would like to not be included in the averaging how can I remove them from the formula? |
#2
|
|||
|
|||
try this average if formula. It is an ARRAY formula so must be entered using
ctrl+shift+enter =AVERAGE(IF(K1:K40,K1:K4)) -- Don Guillett SalesAid Software "elarscott" wrote in message ... I'm using Excel and trying to do averaging using averaging in the formula there are zero's with in the infomration that I would like to not be included in the averaging how can I remove them from the formula? |
#3
|
|||
|
|||
If you have zeros in your data that are real (that you want to include in the
average) and other zeros that represent missing data, then replace the "bad" zeros with blanks. AVERAGE() will not include blanks in its calculation. -- Gary's Student "elarscott" wrote: I'm using Excel and trying to do averaging using averaging in the formula there are zero's with in the infomration that I would like to not be included in the averaging how can I remove them from the formula? |
#4
|
|||
|
|||
Instead of the AVERAGE formula, use.....
=SUM(D1:D8)/COUNTIF(D1:D8,"0") Vaya con Dios, Chuck, CABGx3 "elarscott" wrote in message ... I'm using Excel and trying to do averaging using averaging in the formula there are zero's with in the infomration that I would like to not be included in the averaging how can I remove them from the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
how do i get excel to NOT take zero's of the front of a number | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Removing Hard Borders from Excel Spreadsheet | Excel Worksheet Functions |