I have a spreadsheet and I would like to add up a range of numbers but the
range is variable - I did a named range and that worked great until I did a
sort.

Is it possible for me to have a sum function stop when it reaches a cell
that has the word "stop" typed in a cell? Or can I type a number in a cell
and the number would represent the row number I would like the sum to stop at?

Any suggestions would be great!
Thanks,
Erika