Trying to count holiday taken so far

Hi Everyone,

My manager's asked for something slightly awkward. We have a spreadsheet that plans all holidays taken and planned for the year, but now my manager wants a row at the bottom that counts only holiday days taken to date. All holiday days have H in the cell.

The dates are in descending order in column E, then the employees are in the following columns. I was thinking I could use something that involves the =TODAY() formula, and =COUNTIF with a vlookup? Or am I on the wrong track entirely?