You want to COUNT or SUM?
See COUNTIF and SUMIF in Help, then coma back with more questions
Also have a look at SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Romanli" wrote in message
...
I want to count text/numbers in a range of cells based on a certain
criteria
only the informaiton in another column (same row) meets specific criteria.