I am trying to add this line in to thiswroksheets vba and getting my butt kicked.
I am trying like this
I have tried with and without {} and still get a VALUE error. The "-" are place holders on the sheet. Anyone able to shed any light on how to fix this?
Code:
IFERROR(SUMPRODUCT(A201:E201,A231:E231)/SUM(IF(A231:E231<>""-"",A201:E201)),""-"")
I am trying like this
Code:
Range("E232").Value = Evaluate("{=IFERROR(SUMPRODUCT(A201:E201,A231:E231)/SUM(IF(A231:E231<>""-"",A201:E201)),""-"")}")
I have tried with and without {} and still get a VALUE error. The "-" are place holders on the sheet. Anyone able to shed any light on how to fix this?