=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))

#NAME? error

<tbody>
</tbody>

 

[Jonmo1]

Try changing FormulaR1C1 to just Formula

 

[HockeyDiablo]

That did it. Appreciate that

-J

 

[Jonmo1]

You're welcome.