Find Criteria and then Sum Alphanumeric Cells (Tracking Leave)

**ksews612** · 10-10-2012, 12:03 PM

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,

**icestationzbra** · 10-10-2012, 01:02 PM

this solution is very much tied to the way you enter data in row 2 as well as columns R through AV - i.e., no space between numbers and just the one single alphabet which appears at the end of the string.

also, the indicator alphabet appearing in row 2 (V, P, T, etc.) should be enclosed within parentheses and should be just one in number. this will help you not have to hard-code those indicators in the formulae.