SUMIFS help

SNAP33

New Member
Joined
Jan 5, 2016
Messages
6
[TABLE="width: 2"]
<tbody>[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl70, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl68, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]4
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]5
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]6
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]8
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]9
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]10
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]11
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]12
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]13
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]14
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]15
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]16
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]17
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]18
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]19
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]20
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]21
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]22
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]23
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]24
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]25
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]26
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]27
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]28
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]29
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]30
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]31
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]4
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]44.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I can' figure out the formula to sum the hours based on the type. So there are 3 letter for the time off schedule v (vacation), S (Sick) and E(extra vacation day). The column next to each box with code is hours. I have tried many sum ifs to total the entire month V, S D in 3 columns but I cut get it to sum the total hours
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
[TABLE="width: 1415"]
<colgroup><col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 881;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 881;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 881;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 881;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 881;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1422;"> <tbody>[TR]
[TD="class: xl77, width: 377, bgcolor: transparent, colspan: 15"]1/1/18-1/7/18[/TD]
[TD="class: xl68, width: 377, bgcolor: transparent, colspan: 15"]1/8/18-1/14/19[/TD]
[TD="class: xl68, width: 377, bgcolor: transparent, colspan: 15"]1/15/18-1/21/18[/TD]
[TD="class: xl68, width: 377, bgcolor: transparent, colspan: 15"]1/22/18-1/28/18[/TD]
[TD="class: xl68, width: 377, bgcolor: transparent, colspan: 15"]1/29/18-2/4/18[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]M[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]W[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]F[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl80, bgcolor: transparent"] Total [/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]M[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]W[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]F[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl75, bgcolor: transparent"] Total [/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]M[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]W[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]F[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl75, bgcolor: transparent"] Total [/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]M[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]W[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]F[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl75, bgcolor: transparent"] Total [/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]M[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]W[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]T[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]F[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]S[/TD]
[TD="class: xl75, bgcolor: transparent"] Total [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent, colspan: 2"]1[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]3[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]4[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]5[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]6[/TD]
[TD="class: xl84, bgcolor: transparent, colspan: 2"]7[/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]8[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]9[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]10[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]11[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]12[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]13[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]14[/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]15[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]16[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]17[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]18[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]19[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]20[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]21[/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]22[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]23[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]24[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]25[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]26[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]27[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]28[/TD]
[TD="class: xl71, bgcolor: transparent, colspan: 2"]29[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]30[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]31[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]1[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]2[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]3[/TD]
[TD="class: xl67, bgcolor: transparent, colspan: 2"]4[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"]v[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.8 [/TD]
[TD="class: xl67, bgcolor: transparent"]v[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.8 [/TD]
[TD="class: xl67, bgcolor: transparent"]v[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.8 [/TD]
[TD="class: xl67, bgcolor: transparent"]v[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.8 [/TD]
[TD="class: xl67, bgcolor: transparent"]v[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.8 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl72, bgcolor: transparent"] 44.0 [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"]s[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.0 [/TD]
[TD="class: xl67, bgcolor: transparent"]s[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.0 [/TD]
[TD="class: xl67, bgcolor: transparent"]s[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8.0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl72, bgcolor: transparent"] 24.0 [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"]E[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8 [/TD]
[TD="class: xl67, bgcolor: transparent"]E[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8 [/TD]
[TD="class: xl67, bgcolor: transparent"]E[/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 8 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl72, bgcolor: transparent"] 24.0 [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl72, bgcolor: transparent"] - [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: #EDEDED"] 0 [/TD]
[TD="class: xl72, bgcolor: transparent"] - [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
If you have any control over the design of the workbook, it would be better to have the codes and hours in different rows, one above the other, instead of side-by-side like that. Then it would be pretty easy.
For example, let's say that the code are in cells A4:AE4 and the values are in cells A5:AE5. Then you could just use:
Code:
=SUMPRODUCT(--(A4:AE4="v"),--(A5:AE5))
 
Upvote 0
You could try something like:

=SUM(IF(A4:BI4="v",B4:BJ4))

confirmed with Control+Shift+Enter.
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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