=COUNTIF(B2:B25000,1)
=COUNTIF(B2:B25000,1)

--
HTH,
Bernie
MS Excel MVP


"johli" wrote in message
...

My problem:
I have the survey data in an excel sheet, one respondent per row and
one question per column.

What i would like to do is show the number of grades per question (1-5)
based on several criteria (the first 6 questions) for publishing on a
company intranet.

Could use a pivottable with reformatting of the data but the number of
row would be extremely large (have 25000 respondents and 70 questions)

Have tried using productsum, works but to slow for interactivity.

Would be very grateful for tips of how to do this.
Thinking of creating separate pivot tables for each question but that
would mean a lot of tables :)

/Johan


--
johli
------------------------------------------------------------------------
johli's Profile: http://www.excelforum.com/member.php...o&userid=27388
View this thread: http://www.excelforum.com/showthread...hreadid=469120