A few keystrokes shorter:

=SUM(Name)+NOW()*0

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Lori's suggestion works for me.

An alternative using Bob's suggestion only with worksheet functions is to
make the formula volatile:

=SUM(Name)+TODAY()-TODAY()

--
Biff
Microsoft Excel MVP


"Werner Rohrmoser" wrote in message
...
Lori,

I've made further tests as well and your Excel calculation description
helped me to find out that there is a difference between
using a named formula with relative references and to use a named
relative range
in a formula on a worksheet.

=SUM_Something_Formula vs SUM(Something_relative_Range)

The first possibility has no precednets (checked with the detective)
but the
2nd one has precedents.
So if you test both possibilities the first one doesn't calculate and
the second one does.

This has somekind of logic in connection with the Excel calculation
behaviour.
What's your opinion?

Regards
Werner