MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Whats the best formula for this?

Posted by Dave on November 25, 1999 5:21 PM

I am a novice at Excel and need to know what function to use
to average "text" responses in a survey page I've created online.
For example I pose a question of whether or not the individual lives
in a certain county....YES or NO. I'm seeting up spreadsheet to place the averages
of their responses, i.e. YES 60% and NO 40%. I only want the number returned
to the target cell based on their response from another cell
on another worksheet. I know it's probably rather simple
but I've tried the IF, COUNT functions and others but to no evail. Any help from an experienced user
will be appreciated.

Posted by Scott Schuh on December 21, 1999 7:27 PM

Have you tried the "sumif" function? I think you can probably use this to count the total people people who ARE from a certain country. Then use the "count" function to count totals. Divide the two to come up with your desired results.