| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
You are welcome! Thanks for the feedback!
Stefi Darc ezt *rta: Your a life saver (don't have to individually count 350 entries) - it worked :) "Stefi" wrote: 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
