View Single Post
 
Old 01-15-2016, 10:11 AM
Ted C Ted C is offline Windows XP Office 2007
Novice
 
Join Date: Oct 2011
Posts: 18
Ted C is on a distinguished road
Question COUNTIFS with two criteria returns wrong result

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.
Reply With Quote