Find Criteria and then Sum Alphanumeric Cells (Tracking Leave)

Hello,

I could use some help making the attached worksheet work to my needs. I'm putting together a spreadsheet to track different types of leave. Ideally I would like a formula or function that could search a range (calendar), identify a "type" of time and then add the number associated with the type and give a total in the “taken” columns.

Each Row is an employee and then for each date I track the amount of hours of leave and a letter code for the type of leave (V for Vacation, F for Floating Holiday). Is there a way to do this? I appreciate all the expertise on this site, but my skills are not very advanced so the more detail in your explanation the better for me understand.


Apologies if this have been addressed. I'm still new to this.

Best,