Countif

		Microsoft Office Forums > Microsoft Excel > Excel
Countif

FAQ

Thread Tools

Display Modes

01-04-2013, 12:54 PM

Pecoflyer

Windows 7 64bit Countif

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=SUMPRODUCT(--(left(B2:B2154,4)="2011"))

Your formula looks for a string where XL sees a number

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

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 10:29 AM.