View Single Post
 
Old 12-06-2011, 03:20 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Basically, if you omit the $ symbol in the formula, the cell references will change when you copy it down. As coded, copying gives:
{=SUM(IF(C3=C$1:C$500,1,))}
{=SUM(IF(C4=C$1:C$500,1,))}
{=SUM(IF(C5=C$1:C$500,1,))}
and so on. Without the $ you'd get:
{=SUM(IF(C3=C1:C500,1,))}
{=SUM(IF(C4=C2:C501,1,))}
{=SUM(IF(C5=C3:C502,1,))}
and this would compromise the formula's validity for what you're trying to achieve.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote