# Adding Cells - Simple Formula

#### djorge

##### New Member
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!

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### Norie

##### Well-known Member
What do you actually have in the cells?

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

#### djorge

##### New Member
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

##### Well-known Member
You can post an example of your data and required result using Colo's HTML Maker?

#### djorge

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

Replies
7
Views
107
Replies
1
Views
103
Replies
3
Views
82
Replies
9
Views
174
Replies
10
Views
1K