Bug#267260: openoffice.org: oocalc's countif doesn't work with cell names

[Jim Watson <jim@amarooas.com.au>]

On Saturday 21 August 2004 23:52, David N. Welton wrote:

> And I want to do this:
>
> =COUNTIF(A2:A1000;"<=G2")

Hi Dave,

The second parameter in COUNTIF may be a cell reference where the whole 
criteria string is stored.

this may be done as follows.

B1 <-- enter any cutoff value such as 10
B2 <-- enter condition such as <= 
G2 <-- join these for the criteria such as CONCATENATE(B2;B1)

=COUNTIF(A2:A1000;G2) 

Is this all that you need?

thanks

jim