fetching data from a table

Hi

I need a formula on sheet2, to look at a cell "b3", then go to sheet1, find the column with the value from "b3", then go down the rest of the column and add all the cells containing a certain value like "H" or "LD"
Trying to sort a holiday planner for staff, but I need it to be able to recalculate when inserting new employees.
any help would be appreciated, so that why it needs to look at a certain cell. I've worked out how to add up everything from a certain column, but cannot get it to alter automatically when moving the names down.

Attached the form and the work needs to be on sheet 2, and filling in column "holiday taken", there are a few tries for you to have laugh at.

Thanks

Try:

=COUNTIF(INDEX(Sheet1!$3:$3,MATCH(B3,Sheet1!$3:$3,0)):INDEX(Sheet1!$372:$372,MATCH(B3,Sheet1!$3:$3,0)),"H")

copied down.

or shorter:

=COUNTIF(INDEX(Sheet1!$3:$372,,MATCH(B3,Sheet1!$3:$3,0)),"H")

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save