Sumproduct Troubles
Sent this in ages ago but it never appeared in the group so here we go again
:-)
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
|