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.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional