Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet
I am trying to get the MEDIAN YIELD from a spreadsheet:
I have two columns with figures, which will be going in over a period of time, the next column adds the first two up. As I want the third column to do this as and when figures are entered I have inserted a formula to do it (eg B4+C4). This is where my problem lies as the third column is the data used to get the global Median Yield and because I have inserted the formula to add the first to columns up (each row of two cells) the zeros that are generated give a false reading for the Median Yield. I have tried "Hiding the Zeros" but this does not help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet
Here is a little trick:
Instead of : =B4+C4 use: =IF(COUNTA(B4:C4)=0,"",B4+C4) If both B4 and C4 are empty, the formula yields a blank rather than zero. Most stat functions, such as AVERAGE() ignore blanks. Have a pleasant day! -- Gary's Student "geordie" wrote: I am trying to get the MEDIAN YIELD from a spreadsheet: I have two columns with figures, which will be going in over a period of time, the next column adds the first two up. As I want the third column to do this as and when figures are entered I have inserted a formula to do it (eg B4+C4). This is where my problem lies as the third column is the data used to get the global Median Yield and because I have inserted the formula to add the first to columns up (each row of two cells) the zeros that are generated give a false reading for the Median Yield. I have tried "Hiding the Zeros" but this does not help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Linked Spreadsheets in Excel 2003 | Excel Discussion (Misc queries) | |||
Selling & Protecting An Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Rotating excel spreadsheet for use in photoshop/ using diamond cells tia sal2 | Excel Discussion (Misc queries) | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions |