Hello Rohan
Try: =SUMPRODUCT((A1:A10="YourString")*(B1:B10YourNumb er))

Please note Sumproduct function does not accept entire colum adresses

HTH
Cordially
Pascal

"Rohan" a écrit dans le message de news:
...
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