COUNTIFS with two criteria returns wrong result

		Microsoft Office Forums > Microsoft Excel > Excel
COUNTIFS with two criteria returns wrong result

FAQ

Thread Tools

Display Modes

01-18-2016, 02:34 AM

Debaser

Windows 7 64bit COUNTIFS with two criteria returns wrong result

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Most probable cause is leading or trailing spaces. What do:
=COUNTIF('Combined 2015'!C:C, "Code")
and
=COUNTIF('Combined 2015'!B:B, "WPR")
return respectively?

Tags

countifs

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change	djrobst	Excel	4	10-28-2015 01:32 AM
Clicking the selected Content Control checkbox returns wrong control in vba event	DougsGraphics	Word VBA	2	06-24-2015 07:31 AM
formula, 2 criteria, one result	cjdstephenson	Excel	4	06-02-2015 09:17 PM
Formula returns wrong value	bobsone1	Excel	2	08-19-2014 12:12 AM
IF formula returns wrong result	mashley	Excel	3	09-07-2012 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 AM.