Adding Cells - Simple Formula

[djorge]

This should be simple for anyone who has any experience with excel formulas (I have none!).

I've got a spreadsheet that lists the dates in each payperiod. In each cell we will track whether time off is taken as PTO or Vacation and the number of hours. What I want is at the end of the pay period for the formula to tell me how many hours total for each group (PTO or Vacation). Here's what my sheet looks like:

12 13 14 15 16 19 20 21 22 23 Totals
Employee Name 8v 8p 8v 8v

So in the totals column, I want it to tell me how many total hours are shown for vacation and how many total hours are shown for pto. Obviously, the answer should be 24v and 8p, I just can't figure out how to get it there.

Any help would be appreciated! Merry Christmas!

 

[Norie]

What do you actually have in the cells?

Is it just the number or is it the number and v/p?

 

[djorge]

Clarification of my previous post

Oops, I seen how it posted and want to make sure it makes sense.

Column A contains employee names. Columns B-End contain the dates within the payperiod. On the employee line, if an employee takes time off as PTO, the number of hours taken will be placed in the block corresponding to the date with either a "v" or "p" next to it.

 

[Norie]

You can post an example of your data and required result using Colo's HTML Maker?

 

[djorge]

In the appropriate cell I have the number of hours used and either the letter v or the letter p.