Claus Busch wrote:
Hi Sarah,

Am Thu, 7 Jan 2016 13:53:28 +0000 (UTC) schrieb Sarah H.:

I understand what each function does that you gave,but I don't
quite understand why the INDIRECT works its magic here to help
my situation.

you need the INDIRECT function that only the visible rows in the range
A2:A1000 are calculated.

Thank you, Claus! That makes perfect sense now.

/s