Sorry, Im not thinking my questions through proply and missing bits of.
Ok if I have in range a1:a13 the letters H or S, doesnt matter on order
or how many of each. Then in b1:b13 I have numbers 1 through to 13. Is
it possible to count how many in b1:b13 are greater that 3 if a1:a13 =
S. For instance
a1 = h b1 = 5
a2 =s b2 = 1
a3 = s b3 = 4
a4 = h b4 = 10
etc therefore only 1 meets my criteria. Id like ti use a worksheet
function if possible.
Regards Robert