View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Controlfreak Controlfreak is offline
external usenet poster
 
Posts: 3
Default row by row comparison using a "countif" and "and" condition?

Using Excel 2003. Thanks in advance for the formula to
COUNTIF(F2:F2121,"ABC"" AND (L2:L2121 = "DEF"))?? How can you compare
row-by-row using an and condition vs. going thru the entire column? In other
words, does a row have ABD and DEF simulataneously in 2 separate columns vs
the entire column being evaluated. I have about 2K columns for which each
row must be evaluated 1 by 1 with this and condition.

Thanks very much!