Brandy:
Both of the questions you're asking are pretty straightforward. Here goes:
1) The combo box. First thing is to choose a range ON THE SAME WORKSHEET that contains the values you want for your combo box.
2) Once you have those cells filled out, go to the first cell where you want to have the combo box.
3) Go to your Data menu, and choose "Validation."
4) Under "Allow," choose "List."
5) You'll then be prompted to select the cells, just as if you were inserting a function. Select the cells from Step 1.
6) You'll then see a combo box in the cell. If you want to copy the combo box to additional cells, do this:
a) Copy the cell that has the combo box
b) Select the cells where you want to put it
c) Go Edit->Paste Special, and choose "Validation."
Now, for part two of your question - how to figure out how many times an answer was chosen:
1) Go to the last cell in the range(if you had the answers in rows 1-10, for example, you could go to row 11.)
2) Go Insert->Function
3) Choose the function type Statistical. The function you want is called "COUNTIF."
4) The first argument is the range of cells you want to count. For example, if the answers were in A1:A10, then the first argument would be A1:A10.
5) The second argument is the answer. For example, if the four answers were Red, Blue, Green, and Yellow, then the second argument might be "Yellow." It is important to put the word in quotes. Case, however, is not important.
6) Repeat the process as many times as you need to for the other answers. If you have multiple answers you want to count in the same range, consider doing an absolute reference ($A$1:$A$10, for example) in the function's first argument, so if you copy and paste the Yellow formula for the other colors, then it keeps the same cells.
Don't put yourself down...you're not lame or a dummy. Everyone has to learn this. Good luck.
Cheers,
Geoff Lilley
MCDST, Microsoft Office Master Instructor (2000/XP), Microsoft Office Specialist Master (2000/XP)
[email protected]