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
Range("I49").Select Selection.FormulaArray = _ "=SUM((retrieved_data!F2:F5000=""client9"")*(retrieved_data!J2:J5000=""answered9""))" answered9val = Range("I49").Value