Help with SUMIF formula

[taxchick12]

Excel 2013

I have created a workbook and need some help DESPERATELY. Its used to track and enter vacation into our time system and I created some columns to use for validation/balancing after it is added to our time system.

There can be different types of time off (Vacation(V), Sick(S), Personal(P) and obviously different hours off for each in the time period, and if no time off was taken then the cell will be blank.

I was able to get the COUNTIF fx to work under the COUNT columns, but am not able to get the SUMIF fx to work and have scoured the internet trying to come up with a solution as to why i am not able to make this work.

So what i need to do is SUM the individual types in the corresponding column.

my count formula is =COUNTIF(K2:SF2,"V") and is working fine.

my sum formula was the same and is not working fine! =SUMIF(K2:SF2,"V")
the sum formula is only 1 of at least 20 i have tried and none seem to be working.

any help would be much appreciated.

also tried installing the html thing and can't seem to get it to work on excel 2013, if there are new instructions please let me know where i can find them.




-- removed inline image ---

 

[PCL]

Obviously we need data, can you show how it is.
See the use of the SUMPRODUCT function

 

[taxchick12]

let me see if this works, its a sample from my worksheet.

18-May

19-May

20-May

21-May

22-May

26-May

27-May

28-May

29-May

Total Hours

Count Vacation

Sum Vacation

Count Sick

Sum Sick

Count Personal

S

8

V

8

B

8

J

8

P

8

40

1

0

1

1

<colgroup><col style="mso-width-source:userset;mso-width-alt:938; width:20pt" span="18" width="26"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="width:46pt" span="3" width="62"> <col style="mso-width-source:userset;mso-width-alt:1905;width:40pt" width="54"> <col style="width:46pt" width="62"> </colgroup><tbody>
</tbody>

 

[PCL]

It will seriously easier if you put the data in column:
Date
Ref = V, P, S
Hours
Can you do?

 

[taxchick12]

yes it would be much easier, but this is set up by employee (each employee has a row)and has to be entered into our time keeping system by employee, date, hours, and type (Vacation, Sick, etc).

 

[PCL]

With data From A to R
For Vacation
=COUNTIF($A$2:$R$2,"V")
=SUMPRODUCT(($A$2:$R$2="V")*(OFFSET(($A$2:$R$2),0,1,1,1)))