Chelsie,
Use a Pivot Table. That is the easiest way to slice and dice your data.
Look in help, and/or visit
http://peltiertech.com/Excel/Pivots/pivottables.htm
for a start...
HTH,
Bernie
MS Excel MVP
"Chelsie" wrote in message
...
I need some assistance with some statisical reporting functions of excel. I
know there are simple ways to do this, but I'm pulling a blank.
Problem:
I have a worksheet full of survey results from our classroom evaluations.
For most of the questions, all I need is the average of the answers. But,
for
the demographic information, I need the totals broken down.
For example,
The first question is "Male/Female."
I need a broken down summary of how many manys and how many females per
class so that my sammary page would look like:
Class 1
Males: 9
Females: 14
GPA 2.0 or lower: 6
etc....
Other than the countif function(so I can avoid going through all 500+
classes, is there an easier way to have excel calucate this information
automatically?
thank you in advance.
chelsie