Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add formula in the code
How would I add this formula into the code on Sheet2?
=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add formula in the code
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add formula in the code
Very intuitive and just what I needed ... this makes sense and also helps me
for the other formulas! Thanks! "Tom Ogilvy" wrote in message ... 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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add formula in the code
TIP
To enter formula down a column: With Range("D7:D27") .FormulaR1C1 = "=somefunction(RC1)" End With "Annette" wrote in message ... Very intuitive and just what I needed ... this makes sense and also helps me for the other formulas! Thanks! "Tom Ogilvy" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code the formula? | Excel Discussion (Misc queries) | |||
formula code | Excel Discussion (Misc queries) | |||
formula or code | Excel Worksheet Functions | |||
Not sure if I need a formula or some code.... | Excel Programming | |||
Formula or code | Excel Programming |