=SUMPRODUCT(--(TEXT(A1:A100,"ddmm")="0105"),--(B1:B100="F"))
--
If this post helps click Yes
---------------
Jacob Skaria


"kyoko" wrote:

i really need help on this one. i don't know if it's possible but i still
want to try.
here's the case:
A B
row8 01- May F
row9 01-May D
row10 01-May F
row11 01-May F
row12 02-May F

in this case, i want to return how many "F" on 01-May only. i hope there's a
specific formula for this one. it's a really big help if there is...thanks in
advance.