U
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?
=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?