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

Function has worked for 5 years is now in error
 

The formula is an array formula. You must press Ctrl+Shift+Enter
rather than just Enter when you edit the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"umloew43"
wrote in
message
...

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

Function has worked for 5 years is now in error
 

Thank you, I was hoping it was some little thing I had forgotten. It
works great.


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