Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subset of numbers
Hi Marilyn,
Why not sum the numbers in the range that satisfy the condition and divide by the count of them? Use = sumif(lag_routine_final,"<3")/countif(lag_routine_final,"<3") If you want to avoid ugly error when there are no values less than 3:= if(countif(lag_routine_final,"<3")0,sumif(lag_rou tine_final,"<3")/countif(l ag_routine_final,"<3"),"none") Hope I read the problem correctly. Best wishes Bernard "Marilyn" wrote in message ... I have an array set up with a column of "days" in it. I want a subset of those numbers for any days that are less than 3. The array is called, "lag_routine_final", so I used countif(lag_routine_final,"<3") which will give me the count, but I need the acutal numbers in a subset so that I can average them. How can I do that? Thank You! Marilyn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of a subset | Excel Worksheet Functions | |||
Sum of subset of an array | Excel Worksheet Functions | |||
Populating a subset | Excel Worksheet Functions | |||
Xcl-create subsets of a set of numbers w/o duplicating the subset | Excel Worksheet Functions | |||
How to enter symbols for subset or element of a subset in Excel? | Excel Worksheet Functions |