CountIF in R1C1 With Ampersand and Address Reference

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

FAQ

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 »

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:17 AM.