From: RobFJ on 16 Feb 2010 06:41 I've got integer values in Rows B and C, columns 1 to 20 I'd like to be able to count the number of times where the column values in rows B and C don't match. Can someone point me in the right direction. TIA Rob From: Max on 16 Feb 2010 07:45 B, C are columns, 1 to 20 are rows Maybe you meant to do this In say, D2: =SUMPRODUCT(--(B2:B20<>C2:C20)) -- Max Singapore --- "RobFJ" wrote:> I've got integer values in Rows B and C, columns 1 to 20 > > I'd like to be able to count the number of times where the column values in > rows B and C don't match From: Mike H on 16 Feb 2010 07:47 Hi, =SUMPRODUCT(--(B1:B20<>C1:C20)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "RobFJ" wrote: > I've got integer values in Rows B and C, columns 1 to 20 > > I'd like to be able to count the number of times where the column values in > rows B and C don't match. > > Can someone point me in the right direction. > > TIA > > > Rob > > > . >  |  Pages: 1 Prev: equationNext: Find a single value from tables by selecting two variable inputs?