Hi,

I am trying to sort a massive excel sheet (information from surveys) when I
try to put in a formula to count how many people "agree, disagree, strongly
agree, stronly disagree" it double adds for the agree and disagree, etc.

I tried using the formula =SUMIF(A2:A350, "Agree") and also formula
=COUNTIF(A2:A350, "*agree*") but like I said, get the numbers doubled when I
put formula =COUNTIF(A2:A350, "*strongly disagree*"). Tells me the agree has
1345 and the stronly agree has 130 and the disagree has 27 and the stronly
disagree has - can't be when there is only 350 surveys. (Only adding one
column)

I tried using the "=" but gives me an error. PLEASE HELP!

Thank You