Need function that will work in Excel 2003 like "Countifs" in 2007
 

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

Need function that will work in Excel 2003 like "Countifs" in 2007
 

The answers you gave for your examples are wrong!

If you're using 8 columns, your returns for the 4 rows should be:

2, 1, 2, 0

With data entered in A1 to H5, with headers in Row 1,
This formula entered in I2, and copied down, will give the returns I
mentioned:

=SUMPRODUCT((A$1:H$1="Rank")*(A2:H2<20))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"RD" wrote in message
...
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

Need function that will work in Excel 2003 like "Countifs" in
 

RagDyeR,

It was very helpful! Your help is greatly appreciated!
--
RD


"RagDyeR" wrote:

The answers you gave for your examples are wrong!

If you're using 8 columns, your returns for the 4 rows should be:

2, 1, 2, 0

With data entered in A1 to H5, with headers in Row 1,
This formula entered in I2, and copied down, will give the returns I
mentioned:

=SUMPRODUCT((A$1:H$1="Rank")*(A2:H2<20))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"RD" wrote in message
...
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

Need function that will work in Excel 2003 like "Countifs" in
 

You're welcome, and thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RD" wrote in message
...
RagDyeR,

It was very helpful! Your help is greatly appreciated!
--
RD


"RagDyeR" wrote:

The answers you gave for your examples are wrong!

If you're using 8 columns, your returns for the 4 rows should be:

2, 1, 2, 0

With data entered in A1 to H5, with headers in Row 1,
This formula entered in I2, and copied down, will give the returns I
mentioned:

=SUMPRODUCT((A$1:H$1="Rank")*(A2:H2<20))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"RD" wrote in message
...
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