Hi I'm trying to work out how to FIND an instance of a name on the vertical
axis, then count any iinstances of a particular text on the horizontal. i.e.

Joe bloggs is in cell A1 on sheet 1 then on sheet 2 he is in cell A10.
Sheet 1 shows what days Joe worked and was on holiday, as does sheet 2.
Sheet 3 "the holiday planner" counts each holiday for joe using the formula
countif. which requires me to choose the correct cell range.

Can I use a formula to find the correct row "joe bloggs" then count the
number of holidays that joe had on seperate sheets?