G Guest Sep 25, 2007 #1 Want to count how many times Column A is greater than Column B and looking for the formula. ex A B 4 2 3 6 1 0 Want result of 2
Want to count how many times Column A is greater than Column B and looking for the formula. ex A B 4 2 3 6 1 0 Want result of 2
G Guest Sep 25, 2007 #3 Thank You VERY Much Peo Sjoblom said: =SUMPRODUCT(--(A1:A100>B1:B100)) -- Regards, Peo Sjoblom Click to expand...
Thank You VERY Much Peo Sjoblom said: =SUMPRODUCT(--(A1:A100>B1:B100)) -- Regards, Peo Sjoblom Click to expand...
