=sumif not turning over properly.

[HockeyDiablo]

I am trying to run this simple code but once its ran, I get these unneeded (U) in th final result and get an error.

Range("B2").Select        ActiveCell.FormulaR1C1 = _
        "=SUMIF(ertwertwertre!T:U,Sheet1!A2,ertwertwertre!U:U)"

This is what the results are and I get an error

=SUMIF(ertwertwertre!T:(U),Sheet1!'A2',ertwertwertre!U:(U))

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"]#NAME? error[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Try changing FormulaR1C1 to just Formula

 

[HockeyDiablo]

That did it. Appreciate that

-J

 

[Jonmo1]

You're welcome.