Can you be more specific in what you mean by that.
If for example it's a survey with multiple choice answers (i.e. A, B
C, D, and E) and Questions (1-10). Assume that question numbers are i
column A, Answers in B, you could use a sumproduct to get the tota
number of Answer "A" for Question 3 like so
=SUMPRODUCT(--($A$1:$A$100=3),--($B$1:$B$100="A"))
You could also add in more information as if you wanted to tabulat
based on other peices of data, such as age, sex, etc. But in al
reality an example would be easier to help with this