Thread: Function has worked for 5 years is now in error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
umloew43
 
Posts: n/a
Default Function has worked for 5 years is now in error

I have been using this formula in a spreadsheet since 2000 in office 97.
=SUM(IF(F2:F50="RL",IF(G2:G500,1,0))). It still works until I try to
modify it. For example change the "RL" to "V". As soon as I try to
change it it gives me an error. Are there any settings I need to
change to allow this function to work and be modifies?


--
umloew43
------------------------------------------------------------------------
umloew43's Profile: http://www.excelforum.com/member.php...o&userid=28950
View this thread: http://www.excelforum.com/showthread...hreadid=486814

Reply With QuoteReply With Quote