In the code below I cannot seem to get the variables of client9 and answer9 to interpolate.
I've tried using "& client9" and "& client9 &" among many other ways, but I still get either an error or the actual string 'client9' and not it's value
client9 and answered9 are dim as strings
and assigned values earlier in the code
Code
Range("I49").Select
Selection.FormulaArray = _
"=SUM((retrieved_data!F2:F5000=""client9"")*(retrieved_data!J2:J5000=""answered9""))"
answered9val = Range("I49").Value
Appreciate help,
/Nick