| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem Plotting/Calculating with #NA
Hello,
I have a series of formula's that I need to exclude N/A values in the calculations. This are the equations I'm trying: IF(ISNA(A1:A14),,AVERAGE(A1:A14)) AVERAGE(A1:A14) As it stands now I have to highlight the formulas -F5 -Special -Formulas/Errors -OK . Delete. This wouldn't be a problem but I sort the data so I have to do this each time I want to view the data from a different sort. If you could find a way to have the formula's ignore the N/A I would really appreciate it. excelBRISKbaby |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with plotting | Excel Discussion (Misc queries) | |||
| Time calculating problem | Excel Discussion (Misc queries) | |||
| Excel 2003 xy chart - problem plotting more than 330 points | Charts and Charting in Excel | |||
| Problem with Calculating Worksheets | Excel Worksheet Functions | |||
| Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
Threaded Mode
