Do you have any #VALUE! errors in any of the referenced ranges?

Try it like this:

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

--
Biff
Microsoft Excel MVP


"Memphus01" wrote in message
...
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?