| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
frequency above a certain number
A1:A10 are numbers
A2 is another number A3 is a formula that states: the number of times A1:A10 is above A2 For example: 5 2 3 5 8 9 4 2 0 1 (numbers) 3 5 (# of times numbers are 3). thanks...! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
frequency above a certain number
One way (assuming you meant A1:J1 rather than A1:A10, since otherwise
you'll get a circular reference): A3: =COUNTIF(A1:J1,"" & A2) In article , SteveC wrote: A1:A10 are numbers A2 is another number A3 is a formula that states: the number of times A1:A10 is above A2 For example: 5 2 3 5 8 9 4 2 0 1 (numbers) 3 5 (# of times numbers are 3). thanks...! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
frequency above a certain number
I'm assuming you mean A1:J1? Try this:
=SUMPRODUCT(--(A1:J1A2)) HTH, Elkar "SteveC" wrote: A1:A10 are numbers A2 is another number A3 is a formula that states: the number of times A1:A10 is above A2 For example: 5 2 3 5 8 9 4 2 0 1 (numbers) 3 5 (# of times numbers are 3). thanks...! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
frequency above a certain number
thanks, works great.
"JE McGimpsey" wrote: One way (assuming you meant A1:J1 rather than A1:A10, since otherwise you'll get a circular reference): A3: =COUNTIF(A1:J1,"" & A2) In article , SteveC wrote: A1:A10 are numbers A2 is another number A3 is a formula that states: the number of times A1:A10 is above A2 For example: 5 2 3 5 8 9 4 2 0 1 (numbers) 3 5 (# of times numbers are 3). thanks...! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
frequency above a certain number
ah, that tricky sumproduct again. thanks!
"Elkar" wrote: I'm assuming you mean A1:J1? Try this: =SUMPRODUCT(--(A1:J1A2)) HTH, Elkar "SteveC" wrote: A1:A10 are numbers A2 is another number A3 is a formula that states: the number of times A1:A10 is above A2 For example: 5 2 3 5 8 9 4 2 0 1 (numbers) 3 5 (# of times numbers are 3). thanks...! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the frequency a number appears with another number within a s | Excel Worksheet Functions | |||
| frequency a number repeats in a column | Excel Worksheet Functions | |||
| Frequency | Excel Discussion (Misc queries) | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| How do I count the frequency of a given number in a column? | New Users to Excel | |||
Linear Mode
