I'm using the following formula in Excel 2010:
When I use Ctrl+D or
Fill down the
$C$2 reference fails to "increment".
Is there any way to fix this?
Try it without the $ signs before the C & the 2. The $ signs act as a hard pointer so the formula currently includes an absolute (static) reference to cell C2.
If you just have 'C2' instead of '$C$2' i.e. a relative reference, when the formula is filled-down it'll increment to D2, E2 and so on.