Thread: [Solved] COUNTIFS with two criteria returns wrong result
View Single Post
 
Old 01-18-2016, 02:34 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
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?
Reply With Quote