I used the following formula
=SUM(INDIRECT("D3:D"&MATCH("Stop",$D$3:$D$500,FALS E)))

The word stop is in cell D27 - it seems to be working great however it stops
summing at cell D25. Any ideas?

"Erika" wrote:

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