i am trying to get the sum of data from column S that meets criteria from
column b and d-

I have been able to get a count using the following formula:
=SUMPRODUCT(--('Sheet2'!$D$6:$D$609="Sr.")*('Sheet2'!$B$6:$B$609 ='Sheet1'!$C6))

following a few examples I found I tried the following but i keep getting
#Value

=SUMPRODUCT(--('Sheet2'!$D$6:$D$609="Sr.")*('Sheet2'!$B$6:$B$609 ='Sheet1'!$C6),'Sheet2'!$S$6:$S$609)

what am I doing wrong?