| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF
I am trying to count just the number of "No Reasons Provided on the
Execptions tab and it counts all the reasons fot the vendor. Using the below formula I get 5 instead of the 3 Vendor Registers Reason Barr Nunn Transportation Inc 2111027 No Reason Provided Barr Nunn Transportation Inc 2131663 No Reason Provided Barr Nunn Transportation Inc 2110528 Truck Problems Barr Nunn Transportation Inc 2110529 Dispatch Error Barr Nunn Transportation Inc 2110530 No Reason Provided =COUNTIF(Exceptions!C:C,LEFT(A12,(LEN(A12)-10))) + COUNT(Exceptions!E:E,"No Reason Provided") any help much thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF | Excel Discussion (Misc queries) | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
![s2m[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
