Keyboard Shortcuts Stopped Working During Formulas

[aberharbie]

Hello,
I'm an avid user of keyboard shortcuts in Excel 2007. Last week, while I was trying to enter a SUMIF formula, I encountered a new issue with a keystroke combination I've been using forever!

Steps to recreate issue:
Assume Months (Jan-Feb) are in A1:A12.
Assume numerical values are in B1:B12.
In C1, type =SUMIF(
Hit left arrow twice to move cursor to A1.
Press and hold CTRL, then press SHIFT, then press down arrow to select A1:A12.

This is when I receive the error:
"You've entered too few arguments for this function. To get help with this function..."

Oddly enough, when I press SHIFT and then press CTRL (instead of CTRL SHIFT), I can continue entering the formula without a problem.

This only started happening recently, and is a problem regardless of the workbook I'm in. It happens with COUNTIF, and any other formula where I'm attempting to select a range without using the mouse.

CTRL+SHIFT+DOWN works properly when not entering a formula, so I know it's not an issue with the keyboard.

I'd be most appreciative for any advice/help resolving this issue.

 

[spoofhopper]

bump, any answers on this?

 

[AhoyNC]

After you select the range with CTRL-SHIFT-DOWN press the comma key which should take you to the next argument in the function. If you press enter you will get the error msg.

 

[spoofhopper]

See steps above to recreate issue: The problem is, while in the sum formula (use sum instead of sumif for this example), when selecting your sum range using ctrl+shift+arrow, once you hit the arrow key the formula editor exits without capturing the sum range, leaving you with just sum(B1) instead of sum(B1:B12).

If the ctrl+shift+arrow functionality within a formula is working, I've been able to recreate this error in Excel 2007 by going to Excel Options-->Advanced and checking/unchecking "Transition navigation keys" under 'Lotus Compatibility.' Once done, cycling the checkbox will not fix the problem.