Need Help With SUMIF Formula In R1C1 Style

		Microsoft Office Forums > Microsoft Excel > Excel
Need Help With SUMIF Formula In R1C1 Style

FAQ

Thread Tools

Display Modes

02-23-2010, 10:05 AM

Todd

Windows Vista Need Help With SUMIF Formula In R1C1 Style

Office 2007

Novice

Join Date: Feb 2010

Posts: 6

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])"

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.