Thread: Insert row above Sum - update formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saintsman Saintsman is offline
external usenet poster
  
Posts: 81
Default Insert row above Sum - update formula
Row value
A1 12
A2 10
A3 6
A4 4
A5 Sum(A1:A4) = 32

I want to insert a row above row 5, but the sum function needs to change to
Sum(A1:A5).
Any ideas

Reply With QuoteReply With Quote