On 19 jul, 16:01, "Otto Moehrbach"
wrote:
Does the range MyTable include the "10" in the total line? * *HTH *Otto"vsoler" wrote in message

...

I have a small table of data, named MyTable:

* * * * * * * * *A * * * * * * A2
* * * * * * * * *1 * * * * * * * *3
* * * * * * * * *5 * * * * * * * *7
* * * * * * * * *Totals * * * 10

When I input the formula =Max(MyTable[#Data]) then I get 10 whereas I
should get 7

I don't think I am wrong!!!

What do you think?

According to the help files, the last line of Totals is not part of
the #Data; if I wanted to include Totals I should use #All instead.

What I did is I created my table as:

A A2
1 3
5 7

Then I went to the menu and added the Totals row; this row is
absolutely not part of #data.