Terrific. I like to give credit where credit is due. Can I use your name? If
so, provide how you'd like it to appear. I'm happy to provide a link to your
web if you have one. :)
************
Anne Troy
www.OfficeArticles.com

"Domenic" wrote in message
...
Hi Anne! It would be my pleasure... :)

As you can see, since the 'Match Type' for the MATCH function is
omitted, it defaults to 1.

As such, the MATCH function searches for the largest value that is less
than or equal to the lookup value and returns its relative position.

Here, the lookup value is 9.9999999999999E+307, which is the highest
number that Excel recognizes. It's a number that won't likely occur in
the range. So MATCH finds the last numerical value in the range and
returns its position.

This number is then used as an argument for the INDEX function which in
turn returns a reference....

=SUM(A2:<Reference Returned by INDEX/MATCH)

Hope this helps!

In article ,
"Anne Troy" wrote:

Dominic: I'd like to add that to my articles. Can you describe it? I'd
LOVE
that. :)
************
Anne Troy
www.OfficeArticles.com

"Domenic" wrote in message
...
Assuming that Column A contains your list and the first row contains
your label, try...

=SUM(A2:INDEX(A:A,MATCH(9.9999999999999E+307,A:A)) )

Hope this helps!

In article ,
"Peter" wrote:

I want to add a total to lists of variable lengths when I don't know
how
long
the list will be. I want to do this by formula and not using the
subtotal
function. Any ideas? Thanks.