[thelist] An excel question (well, Open Office actually)

Ed McCarroll Ed at ComSimplicity.com
Mon Feb 21 19:36:14 CST 2005


> I've got a field for the 1900 and one for the 1999, so 
> ideally I want to be able to put in <=i1 and >=j1 but it 
> gives me 510 error which translates like it's missing a 
> variable, as if I should have something before the <, but 
> that can't be a field because we're applying it to all the range.

IIRC, COUNTIF's "criteria" parameter expects a value, or a cell that evaluates
to one, not a criteria string.

You could create a column that rounds each item down to the first year of it's
applicable range, and then countif() those.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                             http://www.ComSimplicity.com
(310) 838-4330                      PO Box 654, Culver City, CA 90232
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



More information about the thelist mailing list