Residency daily monitoring count numbers with criteria business, date, current fee HELP!

Hi Guys,
I have a general question. Hoping you share your opinions/suggestions.
Any help greatly appreciated.

We have a few residential care homes across UK. I have a workbook where I store all our residents fees which I update daily.
There are 2 worksheets on one I store list of residents on the other one I have a daily breakdown.

What i'd like to do is to use worksheet "daily" to sum fees from "all residents" with criteria like:
- carehome ("daily" row 2),
- fee ("daily" F:K,N:S,V:AA etc)
- date ("daily" C7:C1073).

while fees are on worksheet "all residents" where:
- column A has carehome name on it
- column M to AG has fees on it
- row M3:AG3 has dates on it


for example id like to count in cell F7 how many residents in Branch Court "Bc" were in residency on 12 March 2012 with £520 fee looking on worksheet "all residents" with criteria fee, carehome,date)

Each time one of the council backdates fees or changes a resident to lets say a private one I have to manually change all the numbers which takes time.


I know i made it super complicated, but i'm hoping someone out there done something similar - maybe knows a better way - easier - and will share ideas.

res.xlsx
Thanks

Thank you oeldere, hello Netherlands!
It's not what I need unfortunately.

I need to have residents summed on "daily" sheet depending which business they are from and what date it is.
So for example if we're on "daily" sheet and look at column F which is Branch court "BC" let's say on 04/04/2012 cell C36 we get the number of residents on rate £520 that day getting information from "all residents" sheet looking at setting, date, fee


Now I see that i've put random fees just to see if i can come up with something but I hope you get my idea.

there's amended file.res.xlsx
I'm loosing hope guess I'm making it too complicated.. there must be an easier way of daily tracking residents number on a given fee.

that's the hard part.
rates are in N:AH "all residents" current rate is always the one on the far right. fees i enter manually whenever they change for resident/s.

the red/brown highlights in "daily" need to look in "all residents" and match the fee to date.
so for example:

cell F10 has a formula that searches columns N:AH "All residents" and counts residents on rate 520 on 12 mar 2012

i guess i should think again how to do it, as i'm only bringing confusion and making it so complicated... i start feeling stupid
maybe i'll just stick to manual ;(

-double post /sorry - internet issue