# Help with SUMIF formula

#### taxchick12

##### New Member
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 ---

Last edited:

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Obviously we need data, can you show how it is.
See the use of the SUMPRODUCT function

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>

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

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

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

Replies
4
Views
268
Replies
9
Views
97
Replies
2
Views
89
Replies
4
Views
352
Replies
10
Views
231

1,207,111
Messages
6,076,614
Members
446,216
Latest member
BEEALTAIR

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back