I have a formula to look up another workbook and give me how many in colum A say Yes =sumproduct(countif(indirect("'"&$g$1:$g$3&"'!a:a"),"yes"))
you put the workbook names in g1:g3, I was looking to add to the formula to find out how many B:B = CAR and so on but they have to say both on the same row to count as one .