quick Excel question... help!

[tom-mot]

Hi everyone,

I've been swearing at my laptop for the last 2 hours trying to sot what is probably a very simple problem, before I feed it to the oven, can someone help:

I’ve got a grid of data on excel stating the results of a staff survey. Each member of the team has been marked 1-4 (1=good, 4=bad ect) on 18 separate questions.

What I now want to do is be able to collate this data and get excel to tell me how many 1's 2's 3's and 4's there are in each separate column. From this I can then (hopefully) make a nice graph to send upstairs so that the boss can easily see the results.

Is there a function that will allow me to do this or should I give up and go home?!?

Any help would be brilliant!
 

[soybean]

Take a look at the COUNTIF function.

[tom-mot]

you see... i said it was easy and that i was being stupid!

(that will be me missing the check all selector in the function area!)

Cheers.. i can go home now!  

[Michael]

From all those computer users I know, I wonder why 99% of them don't like to use the Help section.
That is a place where you can find answers for most basic questions.
For example, if you want to count something, just type in "count" and search, you'll get most of the options.