|
|
#2
02-22-2010, 02:16 PM
|
|||
|
|||
Hi,
The following works for me: Range("t9").Select ActiveCell.FormulaR1C1 = "=SUMIF(R[1]C[-13]:R[36]C[-13],"">0"",R[1]C[-14]:R[36]C[-14])" Note that the quote character ("), is used as delimiter. If you need it INSIDE your statement, you need to use double quotes (see above). In addition the "=" was missing directly after R1C1 and the quote sign at the end was also missing. I hope this solves your issue! Best regards Bjorn 
|
|
|
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 2003
Threaded Mode