SUMIF Help needed

[orhanceliloglu]

Hi Everyone,

I have an excel file as attached

The issue is : In one row there are values such as "v 8" and "t 8" or " v 4" and "t 4" for half days.

V means vacation
T means training

Basically, I need to calculate total Vacation and Training hours at the end of row. I think I need a SUM IF formula and it needs to separately sum the numbers with v and with t. But I just dont know how

Hope its clear

Please have a look to attached email, you can understand better. At the end, I have two cells (highlighted grey) where I am trying to build the SUMIF formula.

Let me know if you need any other details



Thanks a lot !
Orhan

[Phuocam]

Total V:

=SUMIF($C14:$S14,"v",$D14:$T14)

[Special-K]

Vacation
=SUM(IF(C14:S14="v",D14:T14))
Array formula, use Ctrl-Shift-Enter
Divide by 8 to get number of days


Training
=SUM(IF(C14:S14="v",D14:T14))
Array formula, use Ctrl-Shift-Enter
Divide by 8 to get number of days

[orhanceliloglu]

I love this forum! Never took more then 1 day to take a solution.

Thank you very much. It worked perfectly.

Orhan