Problem whit SUMIFS R1C1 Formula !

[Petter120]

Hi

I am trying to add this formula trough VBA to a cell but gets an #NAME? Error, but when i click in the formula bar and press enter i works perfectly.
I want it to work directly the VBA put it in the cell ?

Please Login or Register  to view this content.

Best regards

Petter

[Petter120]

Ahh got it to work in i use the swedish version and SUMIFS is SUMMA.OMF and i changed it SUMMA.OMF to SUMIFS and it worked perfect