Yes it sounds correct, but...

It's really wierd. That total is a total as added by Excel by checking "Total Row" in the design elements. So, Excel put the 105 there. I don't know what it is.

When I try to just type your suggestion in (while the Total Row is still checked in the Design tab), and it shows 0. If I turn off the Total Row in Design tab, and type in what you list, I get a circular reference error.

Here's a screen capture:



UPDATE

Also, I got to thinking maybe I was typing the formula withing the defined table range, so I moved to the next cell down, and when I type it in, it does not recognize 'duration', and gives me a "Formulat typed contains an error" message.

Not sure what to think.