S
s2m
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
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