Countif

		Microsoft Office Forums > Microsoft Excel > Excel
Countif

01-05-2013, 08:06 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Countif

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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})

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif issue	Katy I	Excel	2	07-11-2012 06:30 AM
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
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:07 PM.