Forum Discussion
Solved
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
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 Reply
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.