| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Why the first row of the subtotal table always not add
Dear Sir,
I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not add
are you sure that d2 is a number and not text?
I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
Hello bj,
I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
when you use subtotal, highlight the area from A1 to D24. I think there lies
the problem. -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Mr. Low" wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
Put =isnumber(D2) in an empty cell.
Do you see True or False? If you see False... select D2 format|cells|general (or any number format--not text) and retype that entry. Mr. Low wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
Ps. If that doesn't work, then post the formula that does the subtotal. Maybe
that cell isn't part of the range to be subtotaled? Mr. Low wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
in an empty cell enter
=d2+d3+d4 and see what you get please paste the formula you have in D5 do you get any difference when you use 9 versus 109 in the function_num position "Mr. Low" wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
looking at your post again, you say you selected A2:D24 and did data-subtotal
It treated row 2 as a title row, so it would not add this to the subtotal try selecting A1:d24 and see what happens (In other words I feel Pranav is correct) "Mr. Low" wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Why the first row of the subtotal table always not
Helo bj,
Yes, you are right. I need to highlight one more row above the foirst row of data to enable the table to add corectly I also have discoverd this by trial and error yesterday. Thanks you anyway. Low -- A36B58K641 "bj" wrote: looking at your post again, you say you selected A2:D24 and did data-subtotal It treated row 2 as a title row, so it would not add this to the subtotal try selecting A1:d24 and see what happens (In other words I feel Pranav is correct) "Mr. Low" wrote: Hello bj, I am very sure that D2 it is a number. Kind Regards Low -- A36B58K641 "bj" wrote: are you sure that d2 is a number and not text? I can'r make it fail on my computer. "Mr. Low" wrote: Dear Sir, I try to use the Subtotal Function at Data Subtotal and find that the first row of the block of data (Cell D2) always not added. Surprisingly this happens to other data table as well. The grand total also short of the amount of the first cell that is omitted . I highlight the data block in cell A2: D24 and follow the default instructions on the dialog box to to get the folowing subtotal table May I know why the amount 282.00 in cell D2 is not added and how to fix this problem ? Can this due to a programing error in the Excel 2002 Spreadsheet ? Thanks Low A B C D 1 Client Ref Date Amount 2 PKHLA491 NK004150 14/08/2007 282.00 3 PKHLA491 NK004151 14/08/2007 672.00 4 PKHLA491 NK004156 14/08/2007 1,332.00 5 PKHLA491 Total 2,004.00 6 PKHLB821 NK004157 14/08/2007 120.00 7 PKHLB821 NK004158 14/08/2007 222.00 8 PKHLB821 NK004159 14/08/2007 112.80 9 PKHLB821 Total 454.80 10 PKHLD208 NK004165 14/08/2007 527.80 11 PKHLD208 NK004166 14/08/2007 338.80 12 PKHLD208 NK004167 14/08/2007 1,055.60 13 PKHLD208 NK004168 14/08/2007 527.80 14 PKHLD208 Total 2,450.00 15 PKHLA491 NK004169 14/08/2007 327.60 16 PKHLA491 NK004170 14/08/2007 201.60 17 PKHLA491 NK004171 14/08/2007 888.00 18 PKHLA491 Total 1,417.20 19 PKHLB821 NK004173 14/08/2007 222.00 20 PKHLB821 NK004174 14/08/2007 225.60 21 PKHLB821 NK004175 14/08/2007 222.00 22 PKHLB821 NK004176 14/08/2007 444.00 23 PKHLB821 Total 1,113.60 24 PKHLK941 NK004177 14/08/2007 1,190.00 25 PKHLK941 NK004178 14/08/2007 177.60 26 PKHLK941 Total 1,367.60 27 PKHLD208 NK004179 14/08/2007 183.60 28 PKHLD208 NK004185 14/08/2007 604.80 29 PKHLD208 NK004186 14/08/2007 201.60 30 PKHLD208 NK004187 14/08/2007 177.60 31 PKHLD208 Total 1,167.60 32 Grand Total 9,974.80 -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal filed in pivot table in Excel? | Excel Worksheet Functions | |||
| How can I color only subtotal lines in Excel 2002? | Excel Worksheet Functions | |||
| Specifying table in Excel 2002 web queries | Excel Discussion (Misc queries) | |||
| display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2002 | Excel Discussion (Misc queries) | |||
Hybrid Mode
