Hi,
I am trying to use variable where needed in the formula but it was not working or I did not know how insert it.
Here below is the formula that I wish to pass.
I want to be able to change these values. On the other hand I tried to enter the formula differently than what you see. the wya it should be is:
I want the criteria to be variable so the "=141060" and the other one can change. Can any one help me write it properly?
The first one above was created using the create macro. I could not figure out how these R and C got written this way.
Regards,
Chuck
I am trying to use variable where needed in the formula but it was not working or I did not know how insert it.
Here below is the formula that I wish to pass.
HTML:
ActiveCell.FormulaR1C1 = _
"=SUMIFS(R[5]C[36]:R[180]C[36],R[5]C[-2]:R[180]C[-2],""=141060"",R[5]C[1]:R[180]C[1],""=4500270213"")"
I want to be able to change these values. On the other hand I tried to enter the formula differently than what you see. the wya it should be is:
HTML:
=SUMIFS("AO5":"AO300", "C5":"C300", "=141060", "F5":"F300", "=4500270213")
I want the criteria to be variable so the "=141060" and the other one can change. Can any one help me write it properly?
The first one above was created using the create macro. I could not figure out how these R and C got written this way.
Regards,
Chuck