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, 05:41 PM

zyzzyva57

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

Office 2007

Expert

Join Date: Mar 2009

Location: Dawsonville, Ga (NE of Atl)

Posts: 355

I think you may have a comma out of place

Here is what I tested with:

=COUNTIF(B1,"<"&TODAY()) = 1

I see with yours perhaps a comma in the wrong place

=COUNTIF(I24:I24,"<"&DP24)

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 02:06 AM.