View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rohan Rohan is offline
external usenet poster
 
Posts: 5
Default Counting with multiple conditions

Hi!

I want to count rows in a worksheet for which column 1 has value =
"some string" and column 2 has value "some number".

I am trying to get this info using COUNTIF function. But looks like
this function has space for only one crieteria.

Is there any way to have this in a excel farmula?

Thanks,
Rohan