#### taxchick12

##### New Member

- Joined
- Jun 15, 2015

- Messages
- 3

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 ---

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 ---

Last edited: