G Guest Feb 4, 2005 #1 i'm trying to count the cell information that's in column b but only if columns a and k equal each other.
i'm trying to count the cell information that's in column b but only if columns a and k equal each other.
J JE McGimpsey Feb 4, 2005 #2 One way: =SUMPRODUCT(--(A1:A1000=K1:K1000),B1:B1000) For an explanation of the "--" see http://www.mcgimpsey.com/excel/doubleneg.html
One way: =SUMPRODUCT(--(A1:A1000=K1:K1000),B1:B1000) For an explanation of the "--" see http://www.mcgimpsey.com/excel/doubleneg.html