This one is really simple but you could make it more complicated if you like. Copy and paste into cell C25 (or wherever you want)

=SUMIFS(Sheet2!$P:$P,Sheet2!$D:$D,$B$6)+SUMIFS(Sheet2!$P:$P,Sheet2!$E:$E,$B$6)