One way...

This data in the range A2:C5 -

Day1...300...290
Day2...310...295
Day3...305...290
Day4...300...285

Your matrix table in the range...

Column headers: A8:F8
Row headers: A9:A16

Enter this formula in B9:

=IF($A9=MEDIAN(INDEX($B$2:$C$5,MATCH(B$8,$A$2:$A$5 ,0),0),$A9),"x","")

Copy across to E9 then down to B16:E16

For the count enter this formula in F9:

=COUNTIF(B9:E9,"x")

Copy down to F16.

--
Biff
Microsoft Excel MVP


"Nestor" wrote in message
...
Hi,
Is there any way in which excel can recognise two numbers as a range? I
would like to create a kind of histogram which can describe how many times
a
point along this range has been crossed over a specific time frame...

For example:

High Low
Day1 300 290
Day2 310 295
Day3 305 290
Day4 300 285

Range Day1 Day2 Day3 Day4 Count
280 0
285 x 1
290 x x x 3
295 x x x x 4
300 x x x x 4
305 x x 2
310 x 1
315 0