Hi all,
I need somebody to help me to do the following:

I have an excel sheet that has two tabs:
1-In the first one"attendance" ,in column B,I have the names of my
employees,and then from column D to column R the weekly attendance.
2-In the second tab"Annual leaves" i have these names in column B,then in
column F i want to count how many times was the word "AL" written infront of
each name in tab "attendance" from column D to column R,i need the results of
this count to be displayed infront of each name in the second sheet "Annual
leaves"