Hi markmellow and welcome to the forum.
See the attached with your answer which takes a SumIf formula.
I see my formula used a SumIf and worked for the first few rows but use the SUMIFS() formula given below by day92 and he got the problem right.
My BAD! Yeah for day92's formula. See it below.
Bookmarks