Add formula in the code

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

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

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

--
Regards,
Tom Ogilvy


"Annette" <[email protected]> wrote in message
news:%[email protected]...
> How would I add this formula into the code on Sheet2?
>
> =SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)
>
>
>

Very intuitive and just what I needed ... this makes sense and also helps me
for the other formulas! Thanks!
"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> 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)"
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Annette" <[email protected]> wrote in message
> news:%[email protected]...
> > How would I add this formula into the code on Sheet2?
> >
> > =SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)
> >
> >
> >
>
>

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


"Annette" <[email protected]> wrote in message
news:[email protected]...
> Very intuitive and just what I needed ... this makes sense and also helps
> me
> for the other formulas! Thanks!
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
>> 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)"
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "Annette" <[email protected]> wrote in message
>> news:%[email protected]...
>> > How would I add this formula into the code on Sheet2?
>> >
>> > =SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)
>> >
>> >
>> >
>>
>>
>
>