You have replies to your previous posting:

One possible change ....

=SUMPRODUCT(--(Sheet1!C39:K39="First"),--(Sheet1!C40:K40="Hit"),Sheet1!C43:K43)

"Sandy" wrote:

On Sheet2 I am trying to total the numbers on Sheet1 in the range
("C43:K43") only when "First" is the value in Range("C39:K39") and "Hit" is
the value in Range ("C40:K40"). I have tried the following to no avail:-

=SUMPRODUCT(--(Sheet1!C39:K39="First"),--(Sheet1!C40:K40="Hit"),--(Sheet1!C43:K43))

Any advice?
Sandy