Advanced Excel COUNTIF/V/HLOOKUP FUNCTION

[SalientAnimal]

Hi All,
So I have a fairly basic calcualtion that I need to do, however structuring the correct formula to use is what seems to be the problem. I have a worksheet where I need to Calculate leave available vs. leave taken.
Part of this would include building a trend pattern to see on which day of the week leave is most often taken. The purpose of this is to see if, as an example, a person is misusing sick leave on a friday to get an "Extend Weekend"
The problem I have is because of the way the document is layout. I have attached the document.
What I need to happen (Example):
1. SHEET (Leave_Matrix) Brian Windsor has taken SLV every friday in January.
2. SHEET (Leave_Trends_Balances) The table (Leave Trends C18:J25) needs to count/calculate 4 SLV on Friday and 1 ALV on Thursday for Brian Windsor.
3. SHEET (Leave_Trends_Balances) Should this trend continue into February as an example the Friday leave count should keep counting over other months. ie. by the end of February, Brian Windsor might have 6 Fridays as SLV.
I hope my explination makes sense of what I am trying to achieve?
Thanks....

Attached available here: http://www.excelbanter.com/showthread.php?p=1602412#post1602412

 

[martindwilson]

cross posted at excel forum
http://www.excelforum.com/excel-general/836034-advanced-excel-countif-v-hlookup-function.html
and excel banter
http://www.excelbanter.com/showthread.php?p=1602412#post1602412

 

[SalientAnimal]

Thanks Martin for addign the cross-post links for me. I forgot to add these.