Hey guys/gals,

First post here, just trying to set something up at work to make using excel easier meaning less manual counting and getting the nice program to do it for me which its designed to do.

Now basically what i'm wanting to do is run a LOOP kind of thing, which i can't see excel has as default ? (might be called something i'm not familiar with)

Basically, i have a spreadsheet, which i want to fill out.

Lets thing of it as rolling a dice... each time certain numbers come up, which i will fill in down a list.. i want it to get added to the total at the top

4
5
6
3
2
4
5
6

I would like the top to say that 6 has came out 2 times. So if i can say start at B9: and work to infinite number (Not sure how many values i will have, as more keep getting added.

So if that makes sense, cause i can't seem to paste the actual table in here

So, just to go over, i want to "sort" through a list and pick out how many times a certain number comes up

Cheers guys/gals! ( I have tried searching but i'm not sure how to word this one! )