|
|
#1
02-21-2010, 02:22 PM
|
|||
|
|||
Need Help With SUMIF Formula In R1C1 Style
The formula is =SUMIF(G10:G45,,">0",F10:F45) I try to add it to a macro using the R1C1 style I get a run time error. Here is what I tried to enter.
Range ("t9") . Select ActiveCell.FormulaR1C1"=SUMIF(R[1]C[-13]:R[36]C[-13],">0",R[1]C[-14]:R[36]C[-14]) This program is about 15 years old and uses many addition and division formulas like the one above. this is the first time trying to use SUMIF in it. Any help would be great. Thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Character style stripped while applying paragraph style | sams_gates | Word | 0 | 08-29-2009 02:03 AM |
| AutoFormat with style | zac | Word | 0 | 01-12-2009 01:12 PM |
| Need to delete style and style text | mclan | Word | 0 | 08-04-2008 12:05 PM |
| Style shortcut | billzant | Word | 0 | 01-06-2007 02:13 AM |
 Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows Vista 
Office 2007
Threaded Mode