Formula Help

[Darc]

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

 

[Stefi]

If you create a list of options in B2:B5

agree
disagree
strongly agree
strongly disagree

then this formula in C2 (filled down to C5) returns the No of matching
replies in A2:A350

=COUNTIF($A$2:$A$350,B2)

Regards,
Stefi


„Darc†ezt írta:

 

[Teethless mama]

COUNTIF(A2:A350, "agree")

COUNTIF(A2:A350, "disagree")

and so on...

 

[Darc]

That does not work - it will combine the disagree and strongly disagree in
the same column ... for example: if I have 30 disagree and 45 strongly
disagree and put this formula in the column where I want to only add disagree
=COUNTIF(A2:A350, "disagree") I will get the combined total of 75 instead of
only 30. There needs to be more to the formula to only pull what I want

Another example - I have 150 females and 100 males ... if I put
=COUNTIF(A2:A250, "males") or =COUNTIF(A2:A250, "males*")... it will say
there is 250 males when actaully I only have 100. Vise versa for females.

Tried SUMIF and SUM and everything - nothing works - gives errormessage

Looking for a more detailed formula.
------------------------------------------------------------------------------------------------

 

[Darc]

Your a life saver (don't have to individually count 350 entries) - it worked

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi


„Darc†ezt írta: