Thread: need help with formula when dragging down
View Single Post
 
Old 03-06-2019, 08:13 AM
bosco_yip bosco_yip is offline Windows 10 Office 2016
Novice
  
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default
Try….........................

=SUM(INDEX('Annual Invoice Breakdown'!$D$3:$Z$5,0,ROWS($1:1)))

or,

=SUM(OFFSET('Annual Invoice Breakdown'!D$3,0,ROWS($1:1)-1,3))

Copied down

Regards
Bosco
Reply With Quote