[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