Quote:
Originally Posted by bobsone1
What is the 105 in your total for?
I.e. in D317 you have =SUM(Table1 [ Duration]).
I tried =SUM(Table1[Duration]) and it looks like it works... Does a total of 539:11:00 (22 days, 12 hours and 11 minutes) sound correct?
|
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.