Thanks for the help. Sorry for the late reply. I must have not turned on email notification.

I tried SUMPRODUCT(), but it yielded a logic error.

Example. A range, named "Data", of the following:

- Code: Select all Expand viewCollapse view
`10.0000`

11.0000

12.0000

13.0000

14.0000

15.0000

16.0000

17.0000

18.0000

19.0000

20.0000

21.0000

22.0000

Human count of the tens: 10 (

=SUMPRODUCT(Data;Data>=10;Data<20) yields 145,

=COUNTIF(Data;AND(Data>=10;Data<20)) yeilds 0)

Human count of the twenties: 3

I believe

COUNTIF(Data,AND(>=10,<20)) would work in Excel, but Calc doesn't like this syntax. But it doesn't like the logic either:

=COUNTIF(Data;AND(Data>=10;Data<20)) yielded 0. Sure, I could sort the actual range of data I'm working with and just use the Count() function (or just use Excel), but I'm trying to get to know Calc better.

Thanks!