What's my best way to automate the cells in yellow - Multi condition - SumIf forumla

[cmckernan1]

Sample data attached

I want to automate the below cells in yellow and link to 'line level' sheet based on cells that are above 0 in column H in the 'line level' tab

[#2 · Accepted solution]

@cmckernan1 

In D19:

=SUMIFS('Line Level'!C$14:C$148,'Line Level'!$B$14:$B$148,$C19,'Line Level'!$H$14:$H$148,">0")

Fill down to D20, then to the right to E19:E20.