SOLVED

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

Copper Contributor

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

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

best response confirmed by cmckernan1 (Copper Contributor)
Solution

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

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.

1 best response

Accepted Solutions
best response confirmed by cmckernan1 (Copper Contributor)
Solution

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

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.