Looking for a correct COUNTIF function

I am using Excel 2003. I have two columns. One columns contains the letter "b" and no data and the other column contains different numbers.
What I am trying to do is count the numbers which are marked "b" and are >= 12.
I tried so many formulas and none of them works.
Here is an example of what I did

=COUNT(IF(C112:C203="b",IF(E112:E203>=DATAVALUE("12"),)))
=COUNTIF(C112:C203="b",E112:E203,">=12")

Please help
Thanks

Try this:

=SUMPRODUCT((C112:C203="b")*(E112:E203>=12))

Hope this helps.

Pete

@ thinkspac

The OP's profile indicates that they have Excel 2003, No COUNTIFS in that version.

Originally Posted by Ron Coderre

For Exel 2003, try this:
=SUMPRODUCT((C112:C203="b")*(E112:E203>=12))

Does that help?

Originally Posted by Pete_UK

Try this:

=SUMPRODUCT((C112:C203="b")*(E112:E203>=12))

Hope this helps.

Pete

Thank you guys, it worked.