The example below is in excel versus access for demonstration purposes. I was able to get the formulas on the attached to work in access but when summarized I need to get $67.43 and not $80.19, how do I exclude the row with no OT when summarizing?
E/N Base Reg OT Total Premium
N $254.71 40 2.8 42.8 $8.33
N $254.71 40 22.2 62.2 $45.45
N $254.71 39.5 0 39.5 $-
N $254.71 40 4.8 44.8 $13.65
$67.43
$1,018.84 159.50 29.80 189.30 $80.19