#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
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? |
#4
|
|||
|
|||
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.
|
Tags |
countifs |
|
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 |