The COUNTIF function uses a number for setting the condition, for example
=COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
this case "<10") with a cell address?
Thank you very much.
Gene

If the condition is in cell D1, then try this:

=COUNTIF(A1:A100,"<"&D1)

Hope this helps.

Pete

On Sep 21, 4:16 pm, "EpsilonRho" <Epsilon...@nospam.ooo> wrote:
> The COUNTIF function uses a number for setting the condition, for example
> =COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
> this case "<10") with a cell address?
> Thank you very much.
> Gene

Thank you very much, Pete. It works.
Gene

"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
If the condition is in cell D1, then try this:

=COUNTIF(A1:A100,"<"&D1)

Hope this helps.

Pete

On Sep 21, 4:16 pm, "EpsilonRho" <Epsilon...@nospam.ooo> wrote:
> The COUNTIF function uses a number for setting the condition, for example
> =COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
> this case "<10") with a cell address?
> Thank you very much.
> Gene

You're welcome, Gene - thanks for feeding back.

Pete

On Sep 21, 4:44 pm, "EpsilonRho" <Epsilon...@nospam.ooo> wrote:
> Thank you very much, Pete. It works.
> Gene
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:(E-Mail Removed)...
> If the condition is in cell D1, then try this:
>
> =COUNTIF(A1:A100,"<"&D1)
>
> Hope this helps.
>
> Pete
>
> On Sep 21, 4:16 pm, "EpsilonRho" <Epsilon...@nospam.ooo> wrote:
>
>
>
> > The COUNTIF function uses a number for setting the condition, for example
> > =COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
> > this case "<10") with a cell address?
> > Thank you very much.
> > Gene- Hide quoted text -
>
> - Show quoted text -

In microsoft.public.excel on Fri, 21 Sep 2007, Pete_UK
<(E-Mail Removed)> wrote :

>If the condition is in cell D1, then try this:
>
>=COUNTIF(A1:A100,"<"&D1)
>
>Hope this helps.

That's useful - thanks.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Hey, thanks for the feedback, Paul.

Pete

On Sep 21, 6:23 pm, Paul Hyett <vidcap...@invalid83261.co.uk> wrote:
>
> That's useful - thanks.
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

In microsoft.public.excel on Fri, 21 Sep 2007, Pete_UK
<(E-Mail Removed)> wrote :

>Hey, thanks for the feedback, Paul.
>
>Pete
>
I have lots of spreadsheets containing temperature data, and being able
to point 'countif' to a single cell will make it a lot easier to count
occurrences of temperatures within a given range, than caving to alter
loads of formulas
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)