=IF(AND(B20,C2=1),1,0)+IF(AND(D20,E2=1),1,0)+IF( AND(F20,G2=1),1,0)+IF(AND(H20,H2=1),1,0)+IF(AND( J20,K2=1),1,0) etc, etc.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Basenji" wrote:

I am using Excel 2003. Column B is the name of the account; column C is a
percentage for the month; column D returns the rank based on the percentage
in column c. Subsequent columns have the following month for a percentage for
that month and the next column is the rank

Column B Column C Column D Column E Column F
Jan Percent Rank Feb Percent
Rank
Account 1 85% 1 78%
2
Account 2 80% 2 82%
1

There are columns for 12 months of percentages and the corresponding columns
for the rank. A formula is needed to count the number of times an account has
a number 1 rank throughout the year, but not count those columns of months
that have not occured as existing formulas return a rank of 1 for each of the
accounts when the percentage is zero for the months that have no percentage.

Thank you.