1

Selecting a range of definite size (e.g. A1:A2) works just fine, but selecting a range to the last row does not. If relevant, I am using Office 365.

Error in formula

phuclv
  • 30,396
  • 15
  • 136
  • 260
Lucca
  • 11
  • 1
  • 2

2 Answers2

2

You can do open references like A:A or 1:1 but cannot mix and match the fixed and open references. To reference the last non-blank cell:

=INDEX(A:A,COUNTA(A:A))

Or the whole non-blank range:

=A1:INDEX(A:A,COUNTA(A:A))
ExcelEverything
  • 3,194
0

Change the C1:C to C:C, it will work for you.

Lee
  • 3,021