Thread: need help with formula when dragging down
View Single Post
 
Old 03-06-2019, 01:33 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by JVenz0913 View Post
The data I am trying to pull is on another sheet within the same book. I just need the Letter of the column to change once i copy and paste the formula down.
Ah yes, I forgot the sheet ref:
=SUM(INDEX('Annual Invoice Breakdown'!$D$3:$Z$5,0,ROW()-13))
Reply With Quote