Hi
I am trying to add this formula to a cell but gets Runtime error 1004 does
anyone know whats wrong with it ?
Best regards![]()
Range("AD4").FormulaR1C1 = "=SUMIFS(R[-2]C[-25]:R[100]C[-25];R[-2]C[-29]:R[100]C[-29];RC[-2];R[-2]C[-26]:R[100]C[-26];R[-1]C)"
Petter
Bookmarks