The following is an example of my database. I am looking for a formula that
will provide me a count of the number of times a "Rank" is less than 20
(<20) at the end of each row.

Stat Rank Stat Rank Stat Rank Stat Rank
20.82 48 19.18 86 24.65 6 23.20 16
23 62 12 6 18 31 17 24
28 18 24 37 29 14 25 28
0.33 38 0.80 24 0.79 25 0.57 31

The answer for row one should be "1"; row 2 should be "1"; row 3 should be
"0"; etc. I don't know if I'm being clear in the description of my needs.
At the end of each row I would like a formula that finds the heading of
"Rank" and evaluates the cell reference for that heading to determine whether
or not it is less than 20 (<20). If it is, then I would like to have it
included in the count, if not, then discard it.

Note: I was able to achieve this outcome when I used "Countifs" in Excel
2007, but now I only have access to Excel 2003 and the "Countifs" formula is
not compatible with this older version.

Thanks for your assistance.

--
RD