| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting values lower then the median.
Thank you in advance for any help anyone may be able to offer.
I have a list of numeric values in column A. in B1 I use the function =median(A1:A150) to get the median value for column A In C1 I would like a count of the values in column A which are LOWER then the Median value in B1 I tried using the =countif(A1:A150, < B1) but i get an error so that is obviously not correct. How do I get this count? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting values lower then the median.
Try...
=COUNTIF(A1:A150,"<"&B1) Hope this helps! In article .com, wrote: Thank you in advance for any help anyone may be able to offer. I have a list of numeric values in column A. in B1 I use the function =median(A1:A150) to get the median value for column A In C1 I would like a count of the values in column A which are LOWER then the Median value in B1 I tried using the =countif(A1:A150, < B1) but i get an error so that is obviously not correct. How do I get this count? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting values lower then the median.
=COUNTIF(A1:A150,"<"&B1)
-- Regards, Peo Sjoblom http://nwexcelsolutions.com wrote in message oups.com... Thank you in advance for any help anyone may be able to offer. I have a list of numeric values in column A. in B1 I use the function =median(A1:A150) to get the median value for column A In C1 I would like a count of the values in column A which are LOWER then the Median value in B1 I tried using the =countif(A1:A150, < B1) but i get an error so that is obviously not correct. How do I get this count? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting values lower then the median.
This works for me:
=SUMPRODUCT(--(ISNUMBER(A1:A150)),--(A1:A150<B1)) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting values lower then the median.
I wrote:
This works for me: SUMPRODUCT(--(ISNUMBER(A1:A150)),--(A1:A150<B1)) ---------- But the other solution is much neater.... :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Distinct Values | Excel Discussion (Misc queries) | |||
| Counting the number of values in a list between two specified valu | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Counting Values on a condition | Excel Worksheet Functions | |||
| If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
Linear Mode
