Cell references stopped working

N

Nick Krill

Cell references have stopped working in my Excel sheets when they are
enclosed in parentheses such as in Sumif or Countif statements as in:

=SUMIF(L11:O11,">c11")

The reference to cell C11 remains lowercase and the program can't find the
referenced cell C11.

This is something that has just started as of this morning and no longer
work, even on existing spreadsheets that have made use of them for months.
 
J

JMB

Enclosed in quotes, excel won't treat C11 as a cell reference, but literally
"c11"
Try:
=SUMIF(L11:O11,">"&c11)
 
J

JMB

Never mind.. I did not see that you posted this question more than once and
it has already been addressed.
 
Top