SUMPRODUCT troubles
"Luke" wrote in message
...
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.
|