I am attempting to compare two different columns. In this case, I am seeking specifically anything that has ".cn" in column A, and the letter "F" in column B. So, the data I have is this: Colum A Column B isp.s01000.cn F isp.s00003.jp isp.s01000.cn F isp.s01000.cn P isp.s01000.cn isp.s01000.cn the formula I am using is (please note, the data starts at row 10in both cases): =SUMPRODUCT(--($A$10:$A$19="*.CN"),--($B$10:$B$19="F")) I've tried this as an Array, and as a basic formula..neither works. Now, in this example, it "should" return 2 as there are 2 instances where Column A has a ".cn" in it, and the directly connected cell B is "F" Any assistance would be greatly appreciated.

There is an Office software forum here.

You should learn a programming language. A simple one like BASIC will allow you too make all sort of comparisons and selections.