B

#### Basenji

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.