that or a frequency table would work great but the problem is that I
would like to count only those rows that fullfill certain criteries.

example

Company Position Gender Q1 Q2 Q3
A 1 1 2 3 3
A 2 2 4 4 5
B 3 1 4 2 4
B 1 2 5 4 3
C 3 2 1 1 1
A 1 1 2 1 4



Based on the selection of a combination of Company and position for
example count the respective number of grades for each question.

like:
Company A
Position 1

Q1 Q2 Q3
1 0 1 0
2 2 0 0
3 0 1 1
4 0 0 1
5 0 0 0


/Johan


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