The formula is =SUMIF(G10:G45,,">0",F10:F45) I try to add it to a macro using the R1C1 style I get a run time error. Here is what I tried to enter.
Range ("t9") . Select
ActiveCell.FormulaR1C1"=SUMIF(R[1]C[-13]:R[36]C[-13],">0",R[1]C[-14]:R[36]C[-14])
This program is about 15 years old and uses many addition and division formulas like the one above. this is the first time trying to use SUMIF in it. Any help would be great. Thanks