Counting instances in 2 columns and showing in 1 cell on another sheet

[raehippychick]

Hi

I am really stuck on where to begin with this... I've tried using IF and COUNTIF and VLOOKUP but I am getting very confused as to a) which one and b) how to do it if I knew which one!

I have a spreadsheet for booking engineers to visit clients

in the "client" sheet:
Column H = Visit Booked For: (formatted as date)
Column I = Engineer Name

In the "engineer" sheet is a basic calendar - days down the side for April to July and the 6 engineer names as column titles

What I would like to do is put a formula in all the relevant cells in the engineer sheet so that it looks at columns H and I in the client sheet and if there is a date in a "Visit Booked" cell it would then look at the cell next to it (column I) for the engineer name entered

if the entered name matches the name at the top of the column in the hols sheet where the formula is then it should return how many times this happens (up to 3 visits per day) in the client sheet, to leave blank or zero if no visits booked

So the final output would be - in the hols sheet how many visits each eningeer did on each day



Many thanks in advance from a very confused blonde hippy!