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" wrote in message
...
How would I add this formula into the code on Sheet2?

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