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