CountIF in R1C1 With Ampersand and Address Reference

		Microsoft Office Forums > Microsoft Excel > Excel
CountIF in R1C1 With Ampersand and Address Reference

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-12-2012, 06:49 PM

MicronExcel MicronExcel is offline

Windows 7 64bit CountIF in R1C1 With Ampersand and Address Reference

Office 2010 64bit

Novice

Join Date: Feb 2012

Posts: 3

FYI--I got it working with the following:

Cells(x, LastColumnNumber + 10).FormulaR1C1 = "=CountIF(R" & x & "C9:R" & x & "C" & LastColumnNumber & ","">""&R" & x & "C" & LastColumnNumber + 8 & ")"

Tags

ampersand, countif, r1c1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF and Cell address problem	ColinC	Excel	3	12-24-2011 04:08 AM
Vlookup, offset, match & countif	jujuwillis	Excel	2	10-15-2011 11:06 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM
how to read R1C1 formula	Suhanti	Excel	2	10-16-2010 11:30 AM
Need Help With SUMIF Formula In R1C1 Style	Todd	Excel	9	02-27-2010 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 AM.