Add formula in the code

[Annette]

How would I add this formula into the code on Sheet2?

=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)

 

[Tom Ogilvy]

What does that mean - add it into the code on sheet2?

If you wanted to use code to enter that formula in a cell you would do:

Worksheets("Sheet2").Range("F6").Formula = _
"=SUMIF(Sheet1!B:B,""warrant"",Sheet1!C:C)"

 

[Annette]

Very intuitive and just what I needed ... this makes sense and also helps me
for the other formulas! Thanks!

 

[Patrick Molloy]

TIP
To enter formula down a column:
With Range("D727")
.FormulaR1C1 = "=somefunction(RC1)"
End With