Re: countif?? by RagDyeR
RagDyeR
Sat May 10 11:18:16 CDT 2008
Your feed-back is appreciated.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"Antonio" <Antonio@discussions.microsoft.com> wrote in message
news:FFFBEEE9-AED1-49F2-9BB1-F0BAB6F1DAD4@microsoft.com...
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" <Antonio@discussions.microsoft.com> wrote in message
> news:FD86C78E-6597-4D0B-9F82-93B2C9587167@microsoft.com...
> > 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" <MikeH@discussions.microsoft.com> wrote in message
> >> > > news:A76EE035-4661-4BA0-8D34-40F3E7BDB385@microsoft.com...
> >> > > > 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
> >> > >
> >> > >
> >> > >
>
>
>