I am working on a Paid Time Off calendar for the employees of our company and
would like to have a formula to calculate ONLY how much PTO has been taken.
I currently have a formula that takes the 2008 carry over (AR2) adds the
accrual rate (AU1) multiplied by two (number of times paid each month) and
then deducts the number of hours taken each month. I have separate cells for
the number of hours taken off, the absence code (i.e. "p" for PTO, "b" for
Bereavement, etc.), accrual rate and 2008 carry over.

The formula I would like to create would only subtract those absence code
cells with a "p". See current formula below:

=SUM(AR2,AU1*2)-K22-C24-E24-G24-I24-K24-C26-E26-G26-I26-K26-E28-G28-I28-K28-C30-E30-G30-I30-K30