Adding Cells - Simple Formula

djorge

New Member
Joined
Dec 18, 2005
Messages
4
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!
 

Some videos you may like

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
Joined
Apr 28, 2004
Messages
76,052
Office Version
  1. 365
Platform
  1. Windows
What do you actually have in the cells?

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

djorge

New Member
Joined
Dec 18, 2005
Messages
4
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.
 

djorge

New Member
Joined
Dec 18, 2005
Messages
4
In the appropriate cell I have the number of hours used and either the letter v or the letter p.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,289
Messages
5,571,323
Members
412,382
Latest member
Langtn02
Top