Help with Array formula in VB

[Crisp and Dry]

Hi,

Can someone tell me how I write the array formula below using the Selection.FormulaArray in VB please.

{=SUM((All!I1:I1000="Convert")*(All!K1:K1000="AW"))}

 

[VoG]

Hi. Try

Selection.FormulaArray = "=SUM((All!I1:I1000=""Convert"")*(All!K1:K1000=""AW""))"

 

[Crisp and Dry]

Cheers VoG