JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,543
- Office Version
- 365
- Platform
- Windows
I am stumped. I have uploaded a workbook to this Dropbox folder:
I have defined several "dynamic" named ranges. For example, Column D contains the Biden votes for each state in the 2020 election. Row 7 has been assigned the name "Header" and row 64 has been assigned the name 'Footer". This allows me to define a named range (VotesBiden) as
This works perfectly in D4 (
What am I doing wrong?
I have used dynamic ranges like this many, many times and they always work.
Thanks
I have defined several "dynamic" named ranges. For example, Column D contains the Biden votes for each state in the 2020 election. Row 7 has been assigned the name "Header" and row 64 has been assigned the name 'Footer". This allows me to define a named range (VotesBiden) as
VBA Code:
=OFFSET(@'Final Tallies'!Header,1,0):OFFSET(@'Final Tallies'!Footer,-1,0)
This works perfectly in D4 (
=SUM(VotesBiden)
) but fails in K8, L8, and E8.What am I doing wrong?
I have used dynamic ranges like this many, many times and they always work.
Thanks