Update 23 November: As some have noticed, would it not be easier to just do a window_sum(sum[hour_hours])) and compute that by Answer is: yes. The original question was phrased differently with the user asking to also deduct several values which, in retrospect was not what he wanted. All he wanted was to just sum the … Continue reading Mimicing Excels sumif / Vlookup without data manipulation