Thread: DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angie G. Angie G. is offline
external usenet poster
  
Posts: 1
Default DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE
Have following formula on cell J1
(=SUMPRODUCT(--($C$3:$C$157DATE(2008,9,30)),--($C$3:$C$157<DATE(2008,11,1)),$G$3:$G$157)
If I insert a line on row 3, formula changes to $C$4 and $G$4, I want it to
stay as formula is written. Is it possible?
Reply With QuoteReply With Quote