| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate average value in a row ignoring values below "x"
i am trying to calculate the average of a column for values above 25000 using
following formula : =average(if(c8:c10025000,c8:c100,"")) but can't get it working - any good ideas ? - thanks !! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to calculate average value in a row ignoring values below "x"
Try:
=SUMIF(C8:C100,"25000") / COUNTIF(C8:C100,"25000") "ed both" wrote: i am trying to calculate the average of a column for values above 25000 using following formula : =average(if(c8:c10025000,c8:c100,"")) but can't get it working - any good ideas ? - thanks !! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to calculate average value in a row ignoring values below "x"
=AVERAGE(IF(C8:C10025000,C8:C100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ed both" wrote in message ... i am trying to calculate the average of a column for values above 25000 using following formula : =average(if(c8:c10025000,c8:c100,"")) but can't get it working - any good ideas ? - thanks !! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to calculate average value in a row ignoring values below "x"
=average(if(c8:c10025000,c8:c100))
Enter with Ctrl+Shift+Enter rather than Enter "ed both" wrote: i am trying to calculate the average of a column for values above 25000 using following formula : =average(if(c8:c10025000,c8:c100,"")) but can't get it working - any good ideas ? - thanks !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Need help with formula to average numbers while ignoring "0" value | Excel Worksheet Functions | |||
| "ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
