![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
countifs |
|
![]() |
||||
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 |
![]() |
DougsGraphics | Word VBA | 2 | 06-24-2015 07:31 AM |
![]() |
cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
![]() |
bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |