Spreadsheet: 90489d1290191157-find-the-sum-of-all-the-cells-in-a-column-which-have-a-certain-value-to-the-left-help
Sheet: Sheet1

Date | Work order | employer | whatever
2010-11-18 00:00:00 | 034798 | RSOT | 0.81
2010-11-18 00:00:00 | 034798 | RSOT | 0.72
2010-11-18 00:00:00 | 034792 | RSOT | 0.95
2010-11-18 00:00:00 | 034792 | RSOT | 1.77
2010-11-18 00:00:00 | 034770 | CMCG | 0.5
2010-11-18 00:00:00 | 034770 | CMCG | 0.83
2010-11-18 00:00:00 | 034746 | CMCG | 0.92
2010-11-18 00:00:00 | 034746 | CMCG | 0.17
2010-11-18 00:00:00 | 034746 | CMCG | 0.16
2010-11-18 00:00:00 | 034746 | CMCG | 0.17
2010-11-18 00:00:00 | 034746 | CMCG | 0.25
2010-11-18 00:00:00 | 034746 | CMCG | 0.08
2010-11-18 00:00:00 | 034742 | CMCG | 0.5
2010-11-18 00:00:00 | 034742 | CMCG | 0.58
2010-11-18 00:00:00 | 034737 | WEST | 0.38
2010-11-18 00:00:00 | 034737 | WEST | 2.15
2010-11-18 00:00:00 | 034737 | KPAR | 0.37
2010-11-18 00:00:00 | 034737 | KPAR | 0.6
2010-11-18 00:00:00 | 034737 | KPAR | 0.38
2010-11-18 00:00:00 | 034737 | KPAR | 2.15
2010-11-18 00:00:00 | 034621 | SGRA | 0.41
2010-11-18 00:00:00 | 034621 | SGRA | 2.02
2010-11-18 00:00:00 | 034620 | CMCG | 0.75
2010-11-18 00:00:00 | 034620 | CMCG | 2.5
2010-11-18 00:00:00 | 033795 | WEST | 0.22
2010-11-18 00:00:00 | 033795 | WEST | 0.1
2010-11-18 00:00:00 | 033795 | WEST | 1.53
2010-11-18 00:00:00 | 033795 | WEST | 0.37
2010-11-18 00:00:00 | 033795 | WEST | 0.6
2010-11-18 00:00:00 | 033795 | KPAR | 0.22
2010-11-18 00:00:00 | 033795 | KPAR | 0.1
2010-11-18 00:00:00 | 033795 | KPAR | 1.53
2010-11-18 00:00:00 |  | WEST | 0.87
2010-11-18 00:00:00 |  | WEST | 0.28
2010-11-18 00:00:00 |  | TFER | 5
2010-11-18 00:00:00 |  | TFER | 3.25
2010-11-18 00:00:00 |  | SGRA | 0.58
2010-11-18 00:00:00 |  | SGRA | 0.22
2010-11-18 00:00:00 |  | RSTR | 2.37
2010-11-18 00:00:00 |  | RSTR | 0.11
2010-11-18 00:00:00 |  | RSTR | 0.35
2010-11-18 00:00:00 |  | RSTR | 0.17
2010-11-18 00:00:00 |  | RSTR | 0.5
2010-11-18 00:00:00 |  | RSTR | 6.5
2010-11-18 00:00:00 |  | RSOT | 0.45
2010-11-18 00:00:00 |  | RSOT | 0.37
2010-11-18 00:00:00 |  | RSOT | 0.03
2010-11-18 00:00:00 |  | KPAR | 0.87
2010-11-18 00:00:00 |  | KPAR | 0.28
2010-11-18 00:00:00 |  | EDOV | 4.58
2010-11-18 00:00:00 |  | EDOV | 4.17
2010-11-18 00:00:00 |  | CMCG | 0.42
2010-11-18 00:00:00 |  | CMCG | 0.17
2010-11-18 00:00:00 |  | CMCG | 0.25
2010-11-17 00:00:00 | 034775 | ORHO | 0.37
2010-11-17 00:00:00 | 034775 | ORHO | 0.9
2010-11-17 00:00:00 | 034775 | JHAR | 0.35
2010-11-17 00:00:00 | 034775 | JHAR | 0.93
2010-11-17 00:00:00 | 034774 | ORHO | 2.48
2010-11-17 00:00:00 | 034774 | JHAR | 0.34
2010-11-17 00:00:00 | 034774 | JHAR | 2.13
2010-11-17 00:00:00 | 034773 | DPEA | 0.29
2010-11-17 00:00:00 | 034773 | DPEA | 0.66
2010-11-17 00:00:00 | 034769 | DRIF | 1.08
2010-11-17 00:00:00 | 034769 | DRIF | 1.79
2010-11-17 00:00:00 | 034766 | ORHO | 0.07
2010-11-17 00:00:00 | 034766 | ORHO | 1.18
2010-11-17 00:00:00 | 034766 | JHAR | 0.07
2010-11-17 00:00:00 | 034766 | JHAR | 1.18
2010-11-17 00:00:00 | 034765 | DPEA | 0.67
2010-11-17 00:00:00 | 034765 | DPEA | 0.41
2010-11-17 00:00:00 | 034763 | ORHO | 0.8
2010-11-17 00:00:00 | 034763 | ORHO | 1.7
2010-11-17 00:00:00 | 034763 | JHAR | 0.8
2010-11-17 00:00:00 | 034763 | JHAR | 1.7
2010-11-17 00:00:00 | 034758 | KPAR | 0.28
2010-11-17 00:00:00 | 034758 | KPAR | 0.4
2010-11-17 00:00:00 | 034758 | KPAR | 0.17
2010-11-17 00:00:00 | 034758 | KPAR | 3.15
2010-11-17 00:00:00 | 034758 | KPAR | 2.5
2010-11-17 00:00:00 | 034758 | CRIF | 0.28
2010-11-17 00:00:00 | 034758 | CRIF | 0.4
2010-11-17 00:00:00 | 034758 | CRIF | 0.17
2010-11-17 00:00:00 | 034758 | CRIF | 3.15
2010-11-17 00:00:00 | 034758 | CRIF | 2.5
2010-11-17 00:00:00 | 034756 | DRIF | 0.8
2010-11-17 00:00:00 | 034756 | DRIF | 0.58
2010-11-17 00:00:00 | 034753 | DPEA | 0.5
2010-11-17 00:00:00 | 034743 | CMCG | 0.42
2010-11-17 00:00:00 | 034743 | CMCG | 0.58
2010-11-17 00:00:00 | 034739 | CMCG | 0.83
2010-11-17 00:00:00 | 034739 | CMCG | 0.92
2010-11-17 00:00:00 | 034735 | CMCG | 0.67
2010-11-17 00:00:00 | 034735 | CMCG | 0.25
2010-11-17 00:00:00 | 034728 | CMCG | 0.75
2010-11-17 00:00:00 | 034728 | CMCG | 0.5
2010-11-17 00:00:00 | 034720 | DPEA | 0.5
2010-11-17 00:00:00 | 034720 | DPEA | 0.88
2010-11-17 00:00:00 | 034716 | CMCG | 0.83
2010-11-17 00:00:00 | 034716 | CMCG | 1
2010-11-17 00:00:00 | 034706 | ORHO | 0.33
2010-11-17 00:00:00 | 034706 | ORHO | 1.5
2010-11-17 00:00:00 | 034706 | JHAR | 0.33
2010-11-17 00:00:00 | 034706 | JHAR | 1.5
2010-11-17 00:00:00 | 034689 | DRIF | 0.78
2010-11-17 00:00:00 | 034689 | DRIF | 1.02
2010-11-17 00:00:00 | 034341 | CMCG | 0.25
2010-11-17 00:00:00 | 034341 | CMCG | 3.75
2010-11-17 00:00:00 |  | TFER | 5
2010-11-17 00:00:00 |  | TFER | 3
2010-11-17 00:00:00 |  | RSTR | 5
2010-11-17 00:00:00 |  | RSTR | 3.5
2010-11-17 00:00:00 |  | ORHO | 0.5
2010-11-17 00:00:00 |  | ORHO | 0.58
2010-11-17 00:00:00 |  | ORHO | 0.59
2010-11-17 00:00:00 |  | KPAR | 0.25
2010-11-17 00:00:00 |  | KPAR | 0.17
2010-11-17 00:00:00 |  | KPAR | 0.25
2010-11-17 00:00:00 |  | KPAR | 0.36
2010-11-17 00:00:00 |  | KPAR | 0.39
2010-11-17 00:00:00 |  | JHAR | 0.17
2010-11-17 00:00:00 |  | JHAR | 0.41
2010-11-17 00:00:00 |  | JHAR | 0.59
2010-11-17 00:00:00 |  | EDOV | 4.5
2010-11-17 00:00:00 |  | EDOV | 3.5
2010-11-17 00:00:00 |  | DRIF | 0.5
2010-11-17 00:00:00 |  | DRIF | 0.45
2010-11-17 00:00:00 |  | DPEA | 1.25
2010-11-17 00:00:00 |  | DPEA | 1.17
2010-11-17 00:00:00 |  | CRIF | 0.17
2010-11-17 00:00:00 |  | CRIF | 0.23
2010-11-17 00:00:00 |  | CRIF | 0.38
2010-11-17 00:00:00 |  | CRIF | 0.39
2010-11-17 00:00:00 |  | CRIF | 0.25
2010-11-17 00:00:00 |  | CMCG | 0.25
2010-11-17 00:00:00 |  | CMCG | 0.25
2010-11-17 00:00:00 |  | CMCG | 0
2010-11-16 00:00:00 | 034782 | RSOT | 0.47
2010-11-16 00:00:00 | 034782 | RSOT | 0.6
2010-11-16 00:00:00 | 034782 | JHAR | 0.25
2010-11-16 00:00:00 | 034782 | JHAR | 1.25
2010-11-16 00:00:00 | 034755 | JHAR | 0.55
2010-11-16 00:00:00 | 034755 | JHAR | 0.95
2010-11-16 00:00:00 | 034740 | DPEA | 0.67
2010-11-16 00:00:00 | 034740 | DPEA | 0.66
2010-11-16 00:00:00 | 034733 | ORHO | 0.37
2010-11-16 00:00:00 | 034733 | ORHO | 0.63
2010-11-16 00:00:00 | 034733 | JHAR | 0.37
2010-11-16 00:00:00 | 034733 | JHAR | 0.63
2010-11-16 00:00:00 | 034733 | DRIF | 0.53
2010-11-16 00:00:00 | 034733 | DRIF | 0.5
2010-11-16 00:00:00 | 034729 | FLON | 0.5
2010-11-16 00:00:00 | 034729 | FLON | 1.5
2010-11-16 00:00:00 | 034726 | RSOT | 0.96
2010-11-16 00:00:00 | 034726 | RSOT | 1.17
2010-11-16 00:00:00 | 034726 | LMES | 0.96
2010-11-16 00:00:00 | 034726 | LMES | 1.17
2010-11-16 00:00:00 | 034724 | THOL | 0.35
2010-11-16 00:00:00 | 034724 | THOL | 2.2
2010-11-16 00:00:00 | 034723 | ORHO | 0.58
2010-11-16 00:00:00 | 034723 | ORHO | 0.42
2010-11-16 00:00:00 | 034723 | ORHO | 0.25
2010-11-16 00:00:00 | 034723 | ORHO | 1.75
2010-11-16 00:00:00 | 034723 | JHAR | 0.55
2010-11-16 00:00:00 | 034723 | JHAR | 0.45
2010-11-16 00:00:00 | 034723 | JHAR | 0.25
2010-11-16 00:00:00 | 034723 | JHAR | 1.75
2010-11-16 00:00:00 | 034717 | DPEA | 0.59
2010-11-16 00:00:00 | 034717 | DPEA | 0.66
2010-11-16 00:00:00 | 034716 | FLON | 0.5
2010-11-16 00:00:00 | 034716 | FLON | 0.75
2010-11-16 00:00:00 | 034711 | CMCG | 1.34
2010-11-16 00:00:00 | 034711 | CMCG | 1.08
2010-11-16 00:00:00 | 034709 | DPEA | 0.25
2010-11-16 00:00:00 | 034709 | DPEA | 0.58
2010-11-16 00:00:00 | 034708 | DPEA | 0.5
2010-11-16 00:00:00 | 034708 | DPEA | 0.5
2010-11-16 00:00:00 | 034707 | RSOT | 0.5
2010-11-16 00:00:00 | 034707 | RSOT | 1.8
2010-11-16 00:00:00 | 034707 | LMES | 0.5
2010-11-16 00:00:00 | 034707 | LMES | 1.8
2010-11-16 00:00:00 | 034706 | ORHO | 1.62
2010-11-16 00:00:00 | 034706 | ORHO | 3.38
2010-11-16 00:00:00 | 034706 | JHAR | 1.12
2010-11-16 00:00:00 | 034706 | JHAR | 3.38
2010-11-16 00:00:00 | 034705 | RSOT | 1.14
2010-11-16 00:00:00 | 034705 | RSOT | 0.45
2010-11-16 00:00:00 | 034705 | LMES | 1.14
2010-11-16 00:00:00 | 034705 | LMES | 0.45
2010-11-16 00:00:00 | 034702 | RSOT | 1.11
2010-11-16 00:00:00 | 034702 | LMES | 0.32
2010-11-16 00:00:00 | 034702 | LMES | 1.11
2010-11-16 00:00:00 | 034688 | CMCG | 0.25
2010-11-16 00:00:00 | 034688 | CMCG | 1.75
2010-11-16 00:00:00 | 034688 | CMCG | 1.33
2010-11-16 00:00:00 | 034680 | DRIF | 0.64
2010-11-16 00:00:00 | 034628 | FLON | 0.17
2010-11-16 00:00:00 | 034628 | FLON | 2.08
2010-11-16 00:00:00 | 034576 | RSTR | 0.42
2010-11-16 00:00:00 | 034576 | RSTR | 0.3
2010-11-16 00:00:00 | 034576 | RSTR | 0.2
2010-11-16 00:00:00 | 034576 | KPAR | 0.38
2010-11-16 00:00:00 | 034576 | KPAR | 0.25
2010-11-16 00:00:00 | 034576 | KPAR | 0.4
2010-11-16 00:00:00 | 034576 | KPAR | 3.1
2010-11-16 00:00:00 | 034576 | KPAR | 2
2010-11-16 00:00:00 | 034576 | CRIF | 0.38
2010-11-16 00:00:00 | 034576 | CRIF | 0.25
2010-11-16 00:00:00 | 034576 | CRIF | 0.4
2010-11-16 00:00:00 | 034576 | CRIF | 3.1
2010-11-16 00:00:00 | 034576 | CRIF | 2
2010-11-16 00:00:00 | 034515 | WEST | 0.75
2010-11-16 00:00:00 | 034515 | WEST | 0.47
2010-11-16 00:00:00 | 034515 | WEST | 0.38
2010-11-16 00:00:00 | 034515 | WEST | 2.32
2010-11-16 00:00:00 | 034515 | WEST | 0.5
2010-11-16 00:00:00 | 034515 | RSTR | 0.25
2010-11-16 00:00:00 | 034515 | DRIF | 0.75
2010-11-16 00:00:00 | 034515 | DRIF | 0.47
2010-11-16 00:00:00 | 034515 | DRIF | 0.38
2010-11-16 00:00:00 | 034515 | DRIF | 2.32
2010-11-16 00:00:00 | 034515 | DRIF | 0.5
2010-11-16 00:00:00 | 034418 | RSOT | 0.42
2010-11-16 00:00:00 | 034418 | RSOT | 0.36
2010-11-16 00:00:00 | 034418 | LMES | 0.42
2010-11-16 00:00:00 | 034418 | LMES | 0.36
2010-11-16 00:00:00 | 034402 | RSOT | 0.32
2010-11-16 00:00:00 | 034341 | CMCG | 0.25
2010-11-16 00:00:00 | 034341 | CMCG | 4.17
2010-11-16 00:00:00 | 034341 | CMCG | 0.17
2010-11-16 00:00:00 | 034341 | CMCG | 0.33