Function has worked for 5 years is now in error

  • Thread starter Thread starter umloew43
  • Start date Start date
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?
 
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"
message
news:[email protected]...
 
Thank you, I was hoping it was some little thing I had forgotten. It
works great.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill handle formula 9
Complicated working days function 7
Show data depending on value 2
Complicated working days calculation 1
range label works in VLOOKUP except if refenced in another cell 3
IF AND Nested Functions - Formula Not Working 0
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT 4

Back
Top