I have "dates" in Col. A and about 15 values in Col. B corresponding to each date.
For example,
Row # Date Value
Row 1 - 1/1/2010 - 10
...............................
Row 15 - 1/1/2010 - 65
Row 16 - 1/2/2010 - 20
--------------------------------
Row 30 - 1/2/2010 - 25

I need to count the number of values exceeding a certain number corresponding to each date. For ex., for 1/1/2010, the value = 5 (5 times the number '50' was exceeded within the range Row 1-Row 15). For 1/2/2010, the value = 3 (3 times the number '50' was exceeded within the range Row 16-Row 30).

Can somebody provide me with a formulae in Excel 2007 to do this?

Thanks