Jennifer,

Change

A1<A$1:A$12

to

A1A$1:A$12


HTH,
Bernie
MS Excel MVP


"Jennifer" wrote in message
...
I am using the below formula to rank a column. I want whoever has the lowest
number to be ranked #1 and so forth. Any suggestions?

=IF(A1="","",SUMPRODUCT(--(A1<A$1:A$12),1/COUNTIF(A$1:A$12,A$1:A$12&""))+1)