I need help with Microsoft Excel Please

[Eaglesfan27]

Quick background.. I'm trying to prepare a paper to present at the American Academy of Child and Adolescent Psychiatry which meets in October. I've collected a large amount of data on a couple hundred patients (with their consent of course) and I've entered the data into Microsoft Excel.

The problem: I'm trying to calculate the percentage that "true" is answered to one of my questions and the percentage that "false" is answered to one of my questions. I can't seem to get Excel to do this and I've spent about a half hour trying to figure it out and then realized someone might be able to help me much quicker then that annoying little paper clip is doing.

Also, how would I calculate the percentages of three distinct replies to a question: "Too much" "Just right and "too little." Actually I just converted the "Too much" to 1, "just right" to 2, and "too little" to 3, thinking that it would be easier to calculate but it didn't work. (I worked on this problem first)

Any help would be very appreciated.

[FargoFreez aka fof playa]

For your first problem, use:

=count(true)

=count(false)

[FargoFreez aka fof playa]

So to calculate the percents:

=count(true)/"total number of cells" X 100

[Eaglesfan27]

I've tried this and it doesn't seem to be working. I also tried the CountA function which almost does what I need, but it counts all text strings, in addition to the "true" text string.

[Eaglesfan27]

Dola - "Countif" works perfectly! Thanks for your help which was invaluable in figuring this out and saved me a lot more frustration.

[Eaglesfan27]

Double Dola -

I'm really exhilarated as this problem was pissing me off and I really appreciate the help Fargofreez. Now, all of my data is compiled! :) Countif with the thing I wanted counted in quotes such as "true" (after the range of cells in parenthesis) worked for both of my above problems and now I'm ready to write up my data tomorrow (as well as some background info, methods, and such)

Thanks again for the help :)

On a seperate note, I now can see how my first season of my new career in FOF2004 ends. I traded away a lot of draft picks to really upgrade the team around Donovan (Hines Ward, London Fletcher, Sammy Knight, and Eric Steinbach all being added via trades and significantly upgrading their positions) in the very first year of this new career, but injuries have hit me hard and it will be tough in the playoffs despite my bye. By the way, I really like how if you back out of a deal, the computer will ask for a tougher deal to accept it. I foolishly backed out of a deal for Hines Ward in which they agreed to a 1st and 3rd round pick for him. To get the deal back on, I had to give up a 1st, 3rd, and 6th round pick.

[finkenst]

Where's FrogMan when you need him?