January 30, 2020
Is there an easy way to sum a range based on a spilled range?
Spilled ranges: B4, E2, and E3.
I need to sum the columns E through I, which are manual entries.
based on the part number and only on the same row as the "Prod" in column D.
The highlighted column J is what I want
Thanks in advance!
February 13, 2021