Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
I want to calculate the average of cells A1, A3, A7, B2 and B5. However, an X
can be in any of the cells as well as a number. How I do this ? I tried AVERAGE(A1+A3+A7+B2+B5) but I get and error if I have an x in any cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
=SUM(A1,A3,A5,B2,B5)/COUNT(A1,A3,A5,B2,B5)
Vaya con Dios, Chuck, CABGx3 "Andy_Trow" wrote: I want to calculate the average of cells A1, A3, A7, B2 and B5. However, an X can be in any of the cells as well as a number. How I do this ? I tried AVERAGE(A1+A3+A7+B2+B5) but I get and error if I have an x in any cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
non adjacent cells give problems in some situations
use a helper row (AA?) in AA1 =A1 in AA2 =A3 inAA3 =A7 in AA4 =B2 in AA5 =B5 then use =average(if(isnumber(AA1:AA5),AA1:AA5)) entered as an array control-shift-enter "Andy_Trow" wrote: I want to calculate the average of cells A1, A3, A7, B2 and B5. However, an X can be in any of the cells as well as a number. How I do this ? I tried AVERAGE(A1+A3+A7+B2+B5) but I get and error if I have an x in any cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
average
AVERAGE ignores text so X's shouldn't be a problem, however you should be
using commas like this =AVERAGE(A1,A3,A7,B2,B5) If you want the X's to count as zero then you can also use AVERAGEA like this =AVERAGEA(A1,A3,A7,B2,B5) "Andy_Trow" wrote: I want to calculate the average of cells A1, A3, A7, B2 and B5. However, an X can be in any of the cells as well as a number. How I do this ? I tried AVERAGE(A1+A3+A7+B2+B5) but I get and error if I have an x in any cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average doesn't average correctly? | Excel Discussion (Misc queries) | |||
average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions |