Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions when using Format as Table
I have annual sales figures for 2 teams. If I create and use Range Names and
perform sums, look for max and min team figures, there's no problem. But when I format my data as a Table, functions don't appear to work correctly for my second team. I have range names TeamA and TeamB. I select TeamA from the name box, from the Formulas Tab I select AutoSum and choose Max, and the result is correct. But when I do the same for TeamB, Excel changes the function to Subtotal, why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined functions format | Excel Discussion (Misc queries) | |||
Complicated Table Functions | Excel Worksheet Functions | |||
Functions in a pivot table | Excel Discussion (Misc queries) | |||
Using Left/Mid functions to format download | Excel Worksheet Functions | |||
cell format for financial functions | Excel Discussion (Misc queries) |