#N/A In Max min Average Formula
I have lots of tables of data e.g. A1:A12 that is linked to line graphs and
max/min/average calculations. The graphs need to plot a zero value when zero is entered but plot nothing when no data is entered. I am entering #N/A into the table, this solves the graph problem but interfears with the max/min/average calculations, they now desplay #N/A. Is there a way to exclude #N/A from the calculations |
Use
=MAX(IF(ISNA(A1:A300)=FALSE,A1:A300)) and array enter it (use ctrl+shift+enter) Same for Min and average "P Beardshall" <P wrote in message ... I have lots of tables of data e.g. A1:A12 that is linked to line graphs and max/min/average calculations. The graphs need to plot a zero value when zero is entered but plot nothing when no data is entered. I am entering #N/A into the table, this solves the graph problem but interfears with the max/min/average calculations, they now desplay #N/A. Is there a way to exclude #N/A from the calculations |
=MAX(IF(ISNUMBER(A1:A12),A1:A12))
entered with ctrl + shift & enter -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "P Beardshall" <P wrote in message ... I have lots of tables of data e.g. A1:A12 that is linked to line graphs and max/min/average calculations. The graphs need to plot a zero value when zero is entered but plot nothing when no data is entered. I am entering #N/A into the table, this solves the graph problem but interfears with the max/min/average calculations, they now desplay #N/A. Is there a way to exclude #N/A from the calculations |
All times are GMT +1. The time now is 02:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com