I'm going to take you at your "word".
You are wanting a formula, not a VBA macro.
Try using countif.
like: =COUNTIF(Data!F:F,"*T*")
this will count  the number of cells in column  "F" of sheet "Data"
that contains the letter "T" in any position.
(you can use "A:AB" to go from columns A to AB, but it will give you
a count of cells, not rows.

If you can give me an idea of what you're trying to accomplish,
maybe I can help you better.