| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Name? Error in User Defined VB Function | Excel Worksheet Functions | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
| Excel Formula - Compute Number of Years Worked | Excel Discussion (Misc queries) | |||
| working with wage tables based on years worked | Excel Discussion (Misc queries) | |||
| weeknum function returns name error | Excel Worksheet Functions | |||
Linear Mode
