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
Human count of the tens: 10 (=SUMPRODUCT(Data;Data>=10;Data<20)
yields 145, =COUNTIF(Data;AND(Data>=10;Data<20))
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.