| Home |
| Search |
| Today's Posts |
|
#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 !! |
| 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 | |||
Threaded Mode
