Function has worked for 5 years is now in error

[umloew43]

I have been using this formula in a spreadsheet since 2000 in office 97. =SUM(IF(F2:F50="RL",IF(G2:G50>0,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?

[Chip Pearson]

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"
<[email protected]> wrote in
message
news:[email protected]...
>
> I have been using this formula in a spreadsheet since 2000 in
> office 97.
> =SUM(IF(F2:F50="RL",IF(G2:G50>0,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
>

[umloew43]

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