Change in column reference

Resolved · Low Priority · Version 2007

Thu 2 May 2013, 12:03 Delegate Lokendra said...

Lokendra has attended:
Excel Advanced course

Change in column reference

In the given formula, I wish to keep the row reference static but keep the column reference changing

DSUM(invoicesdec,'December 2013'!I1,Sheet3!A$5:A$6)

the problem is that both row and column reference remains static. How to correct it?

Thu 2 May 2013, 14:38 Trainer Gary said...

RE: Change in column reference

Hi Lokendra

Thanks for getting in touch. I've tried to replicate your issue with the same formula, and then copied the formula to the right but it's still working. The way you've set out the reference, with the $ symbol before the row, should be perfect.

What happens when you try it?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 8 May 2013: Automatically marked as resolved.

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Change in column reference

Change in column reference

RE: Change in column reference

Excel articles

Excel tip:

Quickly select a block of data