Thread: Adding a additional column in to a sum range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
  
Posts: 90
Default Adding a additional column in to a sum range
Consider keeping 12 sums. Name define the first column sum cell as
ColTotal1. Presuming the choice is in cell A1,

=OFFSET(ColTotal1,0,A1-1)
Reply With QuoteReply With Quote