Try in "A2" sheet1
Formula: copy to clipboard
=SUMIF(Sheet2!$B$4:$B$24,">"&Sheet1!A$1,Sheet2!$A$4:$A$24)

copy paste across