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, 12:33 PM

BjornS

Windows Vista Need Help With SUMIF Formula In R1C1 Style

Office 2003

Competent Performer

Join Date: Jan 2010

Location: Sweden

Posts: 116

Hi Todd,
your macro works fine for me if I only remove the space after Range("t9").
Like this I mean: Range("t9").Select

This gives the following formula result, when running the macro:
=SUMIF(G10:G45,">0",F10:F45)+SUM(N10:N45)+SUMMA(O1 0:O45)
which seems to be correct.

/Bjorn

« 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.