I've looked through the various posts concerning this, but still can't quite
get this to work. I have a ranges named ClaimClients and ClaimStat and a
value named ClientNum. I want to find the number of times the ClaimClients
range has a value of ClientNum and the ClaimStat range has a value of "O".
Here is the code at present:

ActiveCell.Offset(0, 10).Value = ActiveSheet.Evaluate("SUMPRODUCT((" & _
ClaimClients & "=""" & ClientNum & """),(" & ClaimStat & "=""O""))")

With all the various things I've tried to make this work, I always get
either a Type Mismatch error or a Syntax error.