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?
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
