View Single Post
 
Old 02-22-2010, 02:16 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Reply With Quote