Your feed-back is appreciated.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Antonio" wrote in message
...
Tks very much to all for the help given

With this formula, got the expected result

Tks

"RagDyer" wrote:

With data in Column A, this *array* formula will give you the number of
cells between the last 4 and the last cell containing a number:

=MATCH(99^99,A1:A50)-MAX(IF(A1:A50=4,ROW(1:50)))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

This will count cells between the last 4 and the last number, whether or
not
there is any data in those "in-between" cells.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Antonio" wrote in message
...
Hi mike

tryed it, and seems it's not working, because when column
a "grows and more then a 4 in it, returns the total of non 4

"Mike H" wrote:

Then that's what you have in my previous post

"Antonio" wrote:

thats what i lookinf 4

"David Biddulph" wrote:

My reading of the question is that the requirement is to start
counting with
the last non-blank cell in the column, and move up the column
counting up
while the cell value is not 4, and stopping when a 4 is
encountered.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

Why are there only 3 numbers <4 in that list? I count 14 with
this
formula

=COUNTIF((INDIRECT("a1:a" &
MATCH(9.99999999999999E+307,A:A))),"<4")

Mike

"Antonio" wrote:

Hi all

Looking for a formula that count's, from last cell (undifined)
upwards
how
many cell < from 4, which from the list below should return 3

3
5
4
5
3
4
4
2
4
3
4
4
3
5
6
4
4
3
3
4
2
3
2

tks in advance
António