hi AHB10, welcome to the forum. either without the array:
=SUMPRODUCT(($B$17:$B$22="apple")*($C$17:$C$22="green")*$H$17:$H$22*$Q$17:$Q$22)

or if you want your IFS & array:
=SUMPRODUCT(IF($B$17:$B$22="apple",IF($C$17:$C$22="green",$H$17:$H$22))*$Q$17:$Q$22)

if it doesnt work, uploading a sample Excel file will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
ideally, it should contain your desired results