Count? number of different groups of values in a column

Hi, I'm not sure if it is the Count function I need/can use or pivot tables or what for my quandary.

I need to count down columns (51 site columns in total) for every day of the year, of how many of each number group occurs for what number of days. I have attached a small example - Column Site1 has 4 days with 8 stock and 15 days with 7 stock and so on for all columns. So the result I need is basically just that, to tell me that for the whole of Site1 for the year, it had 8 stock for 4 days and 7 stock for 15 days - I don't need to know which days of in what order.

Is there a super duper formula or function that can do this for me please? At the moment I am simply having to select/drag down each number group and record the count shown at the bottom right of the Excel screen for ever column! (365 days for 51 sites with numerous number groups) Highly time consuming and tedious as you can imagine.

Thank you,
kind regards
Lee

Thanks for the replies.
Glen I think your idea may work, it looks like I would need to set up another table like yours, below mine to be able to insert 365 rows worth to enable the calculations to work.
I have to go now but will come back to this tomorrow morning.
See you then hopefully. Thank you

Sorry for the delay, it's been a crazy busy day.
Thanks Glen. Your 2nd idea unfortunately does not give me the info I need eg it just tells me there were 8 stock but not for how many days.
Your first suggestion with COUNTIF does give the correct result but I would need to extend your Stock column to at least 130 to allow for the large numbers of stock that we can get. If there is no other way then your suggestion will still be better me counting manually.
After the comments you both left about how I want the result formatted, I realise it would be quite tricky, if not impossible to get the correct result any better than what you have suggested but I thought Excel could do anything ;-)

Thank you.

That's because I don't know how either!! :-) I don't mind what way just as long as it tells me
Site 1: 8 stock for 4 days; 7 stock for 15 days and so on

Good morning Glenn, Thank you very much for your generous help. I had gone home by the time I saw your last message/suggestion and my brain was frazzled!
Anyway, I have been looking at both your options. You must have a PHd in Excel because your formula is amazing! I am not advanced in Excel so I don't understand it that much but that's ok.
Anyway, an issue in using your sheet is that when I've been in one of your formulated cells and click in the formula bar to see what cells are highlighted, then i click out of the cell, all your data disappears and I can't get it back! Any ideas on why this is happening? I'm not sure i am going to be able to transfer your super formula to my original sheet.

I've just noticed that the squiggly brackets {} (can't recall the name of those!) at the beginning of your formulas disappear when I click in the formulated cells. Should these {} still be part of the formula or do they appear when copying a formula type of thing?!!

Thanks Ali & Glenn. I think I know what you mean. However, same thing is happening. So, after reopening your document Glenn so the data was there, I clicked in a formulated cell and clicked in the formula bar then did Ctrl+Shift+Enter but the same thing happens, all data disappears. I don't understand.
I think this is way beyond my capabilities so I think if I can't get it to work from here then so be it but I thank you for your kind help. I don't want to take anymore of your time.
Glenn you're clearly very clever person - I didn't know veterinary analytical chemistry was in even out there!!
Best wishes.