Array formulas

[szynszyl]

HI!,
please help me to understand what is wrong about this code. Inside destination cell f1 an error message appear.

Range("f1") = [Sum((A2:A10="Fax")*(B2:B10="Brown")*(C2:C10))]

I suppose the errore it's linked to curly braces but i'm not sure.

Thanks
Marco

 

[SkipVought]

Hi,

Range("f1").FormulaArray = "=SUM((A2:A10=""Fax"")*(B2:B10=""Brown"")*(C2:C10))"

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[szynszyl]

Thanks a lot!