SUMIFS with a dynamic, offset criteria range

=SUMIF(OFFSET('Data Sheet'!$A$1,MATCH(SUBSTITUTE($B$4," Total",""),'Data Sheet'!$A:$A,0)-1,3,MATCH($B$4,'Data Sheet'!$A:$A,0)-MATCH(SUBSTITUTE($B$4," Total",""),'Data Sheet'!$A:$A,0)+1,1),C$3,OFFSET('Data Sheet'!$A$1,MATCH(SUBSTITUTE($B$4," Total",""),'Data Sheet'!$A:$A,0)-1,6,MATCH($B$4,'Data Sheet'!$A:$A,0)-MATCH(SUBSTITUTE($B$4," Total",""),'Data Sheet'!$A:$A,0)+1,1))
Try this formula in C4 and copy to D4
One more thing in your Data Sheet unnecessary space was found with purchases pls remove it