Thread: Countif
View Single Post
 
Old 01-05-2013, 08:06 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
To do it with countif:
Code:
=COUNTIF(A:A,">=20110000")-COUNTIF(A:A,">=20120000")
 
or
 
=SUM(COUNTIF(A:A,">=201"&{1,2}&"0000")*{1,-1})
Reply With Quote