Re: Can COUNTIF use a cell as a criteria reference?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 08/04/04

Next message: ABN: "Piviot Table Setup"
Previous message: Frank Kabel: "Re: Change Formula to use Named Range"
In reply to: SteveP: "Can COUNTIF use a cell as a criteria reference?"
Next in thread: SteveP: "RE: Can COUNTIF use a cell as a criteria reference?"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 4 Aug 2004 19:30:22 +0200

Hi
=COUNTIF(B2:B6,"<" & D2)

--
Regards
Frank Kabel
Frankfurt, Germany
SteveP wrote:
> =COUNTIF(B2:B6,"<D2")
>
> This formula always returns the result "0". The cells are formatted
as
> dates. If I convert the range to numbers, and insert a number as the
> criteria, I get the correct result.
>
> 1. Why can't I use a reference as criteria?
>
> 2. Why can' I perform the calculation on dates?
>
> Thanks,
>
> Steve Pretti

Next message: ABN: "Piviot Table Setup"
Previous message: Frank Kabel: "Re: Change Formula to use Named Range"
In reply to: SteveP: "Can COUNTIF use a cell as a criteria reference?"
Next in thread: SteveP: "RE: Can COUNTIF use a cell as a criteria reference?"
Messages sorted by: [ date ] [ thread ]