View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yakimoto Yakimoto is offline
external usenet poster
 
Posts: 10
Default CountIf for two columns

I have two columns populated with different values.
I would like to count all the cells pair having specific values, i.e. like
countif function, but for both cells.
For now I am doing this concatenating both columns and after that performing
CountIf over resulting column.
Another way is to write a piece of code looping and counting, but it seems
too much for such a simple thing.
Is there any other way of doing that? Without intermediate steps, only using
one formula?

Thanks,
Yakimo