Thread: DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE
Yes.

Try
=SUMPRODUCT(--(INDIRECT("$C$3:$C$157")DATE(2008,9,30)),--(INDIRECT("$C$3:$C$157")<DATE(2008,11,1)),INDIRECT ("$G$3:$G$157"))

"Angie G." wrote:

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