How to do a frequency count with criteria?
Posted by KJ on January 27, 2001 10:40 PM
I use the FREQUENCY function frequently, but haven't yet found a way to set criteria. I have datasets with lots of data that fits one of two conditions and I'd like to get frequency counts for each condition. A lot of this is before and after data (eg Child_weight before and after nursing intervention). I'd like to end up with something that looks like a pivot table but counts the number of records between 2 values:
kg, 1, 2
3, 10, 5
6, 20, 25
9, 30, 35
12, 10, 5
Which tells me that before intervention (1) there were 30 children >6kg and <=9kg and afterwards (2) there were 35 in this category.
All bright ideas gratefully accepted