| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need help calculating averages with missing values?
I have tried what they tell me on the help page
=AVERAGE (IF(A2:A7,.0. A2:A7, "")) but it does not work- I really need to figure it out-- any help would be really appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need help calculating averages with missing values?
try
=average(if(a2:a70,a2:a7,"")) hth regards from Brazil Marcelo "avg w/ missing #s" escreveu: I have tried what they tell me on the help page =AVERAGE (IF(A2:A7,.0. A2:A7, "")) but it does not work- I really need to figure it out-- any help would be really appreciated! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need help calculating averages with missing values?
Note that this is an Array Formula. It should be entered with
CTRL-SHIFT-ENTER instead of just Enter. If done properly, the formula should appear in the formula bar with { } surrounding it. HTH, Elkar "Marcelo" wrote: try =average(if(a2:a70,a2:a7,"")) hth regards from Brazil Marcelo "avg w/ missing #s" escreveu: I have tried what they tell me on the help page =AVERAGE (IF(A2:A7,.0. A2:A7, "")) but it does not work- I really need to figure it out-- any help would be really appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate Missing Values | Excel Worksheet Functions | |||
| Calculating Dates Using Different Values for NETWORKDAYS | Excel Worksheet Functions | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
| Excel Charts - Missing Values | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Linear Mode
