Thread: [Solved] Need Help With SUMIF Formula In R1C1 Style
View Single Post
 
Old 02-23-2010, 10:05 AM
Todd Todd is offline Windows Vista Office 2007
Novice
  
Join Date: Feb 2010
Posts: 6
Todd is on a distinguished road
Default
Bjorn
Could you help me again? I decided I wanted to include the sum of two more colums to the formula but again what I entered did not work. Heres what I tried.
Range("t9") .Select
ActiveCell.FormulaR1C1 = "=SUMIF(R[1]C[-13]:R[36]C[-13],"">0"",R[1]C[-14]:R[36]C[-14])+SUM(R[1]C[-6]:R[36]C[-6])+SUM(R[1]C[-5]:R[36]C[-5])"
Reply With Quote