Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the "mean" for a group of numbers
I am trying to find the mean for a groud of numbers, but the formula needs to
exclude any number less then 26. 29,64,90,48,25,0,96,65,50,86,99,0,0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the "mean" for a group of numbers
I have assumed you numbers are in seperate cells. Try this array formula
=AVERAGE(IF(A1:M1=26,A1:M1)) This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the formula {}. You can't type these yourself. If you edit the formula 'you must enter it again with CTRL+Shift+Enter. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "rob" wrote: I am trying to find the mean for a groud of numbers, but the formula needs to exclude any number less then 26. 29,64,90,48,25,0,96,65,50,86,99,0,0 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the "mean" for a group of numbers
=AVERAGE(IF(A1:M1=26,A1:M1)) as an array formula (control, shift, enter)
-- David Biddulph "rob" wrote in message ... I am trying to find the mean for a groud of numbers, but the formula needs to exclude any number less then 26. 29,64,90,48,25,0,96,65,50,86,99,0,0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
deleting or omitting "-"'s in a group of numbers w/ a formula | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
Calculating numbers without using "=" sign ? | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |