Try this array formula** :

=COUNT(D46:INDEX(D46:D61,MATCH(1,(D46:D61<"")*(D4 6:D61<=1.359),0)))/2

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"dlbeiler" wrote in message
...
A picture is worth a thousand words. The following column is D46:D61 with
D52-D54 empty. I need a formula that will proceed through column D and
find
the first occurance of a value that is <= 1.3590, which in this case is
D58.
Then I need to count how many rows of values there are from D46 to D58,
excluding empty cells. Each row is 30 minutes of data and I need the
result
in hours(/2). In this case, Row 58 is 5.0 hours from Row 46.
1.3601
1.3603
1.3604
1.3606
1.3599
1.3600



1.3601
1.3600
1.3599
1.3587
1.3591
1.3591
1.3587


"T. Valko" wrote:

Can you post a sample that depicts what you mean?

--
Biff
Microsoft Excel MVP


"dlbeiler" wrote in message
...
I have a column of random numbers and need to find, from a specific row
forward, the first number that is = than the number in the reference
row.
Then I need to know how many rows away from the reference row
(excluding
empty rows) that number was found in.