My coworker is trying to count documents of particular criteria for reporting purposes. We do reviews of documents submitted to our client, although the review is sometimes waived. We want to be able to count total documents of each type, and how many were waived of that type.

This issue occurs in cell C:4 of the Metric Totals tab. It should return the number of code documents for which the review was waived. The correct number is 15, but the function returns 0.

The function is written as follows:



=COUNTIFS('Combined 2015'!C:C, "Code", 'Combined 2015'!B:B, "WPR" )

The "Combined 2015" tab contains aggregate data on reviews.
Column C contains the document type.
Column B contains whether the document was reviewed or waived: "WPR" indicates it was reviewed.

There are 15 "Code" reviews the the "WPR" value in the "Combined 2015" tab.

The file exceeds the 500 KB upload limit. If this information is not sufficient, I can upload a reduced version of the Excel file.

By all means post a small sample on the board - Thx

__________________
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

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?

While trying to reduce the file size enough to post a copy, I apparently deleted something that kept the function from working. The COUNTIFS function returns correct values in the 497 KB sample I was going to send.