I think your looking more for the count function.

Use this function.
=COUNTIF(A2:A8,"*")

"Mudbug" wrote:

I am trying to run a daily total of the # of responses to 5 questions. Each
question has 5 possible responses. Question 1 had 5 responses rated as 5,
questions 2 had 2 responses rated as 2, etc. I thought I could create a
formula, but I'm stumped. TIA.

Q1 Q2 Q3 Q4 Q5
5 11 7 13 6
2 4 5 6 3
3 4 3 5 4
0 1 0 2 3
0 1 0 0 0

How many 5 responses to question 1?
How many 4 responses to question 1? etc.

Mudbug