Add values where text equals something

vsantoro

New Member
Joined
Mar 21, 2014
Messages
2
hope someone can help.
So i have an excel timesheet output.

Some spots in the excel it will show like this
6 Hrs Straight / 2 Hrs PTO or just pto like this 5 Hrs PTO or maybe no pto.

So basically i want to add up pto value in the entire sheet the value wherever it is "x Hrs PTO"

thank you



<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,535
Members
406,485
Latest member
kaksolver

This Week's Hot Topics

Top