T Tarheel8181 New Member Oct 8, 2014 #1 See attached. Looking for 1 formula that can match text using OR. Any thoughts? Attachments Excel question b.xlsx 10.2 KB · Views: 13
Somendra Misra Excel Ninja Oct 8, 2014 #2 Hi, Try below formula: =SUMPRODUCT(COUNTIF(A2:A4,I3:I8)) Regards,