=SUMPRODUCT(--(Sheet2!$J$1:$J$100=A1),--(Sheet2!$H$1:$H$100="specific
text"))

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Curtis" wrote in message
...
Sheet 1 Column A rows 1 thru 9 = certain different values
Sheet 1 Column B will contain the formula to count the number of instances
in sheet 2 where all the values in column H must = "specific text" and the
values in sheet 2 column J = the values in sheet 1 column A1, a2, a3...


thanks

ce