If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Customise the summation function / button
I have a suggestion in mind for MS Excel 2007 and would like to share with you. At present when a user would like to sum up a group of figure as follows he need to manually enter the formula @sum( ) at the destination cell over and over again. Sub total Sales Sub total 245.36 321.25 125.37 88.14 1,102.25 322.13 1,102.25 1,102.25 300.12 500.21 1,600.65 800.32 1,600.65 100.31 600.38 400.42 1,451.76 50.65 1,451.76 TOTAL : 4,154.66 The existing summation button only allows adding from top to bottom of the last highlighted cell and not to its left or right as indicated in the sub total figures above. As this type of calculation is very frequent in most business , I would like to suggest that the summation button be modified in such a way the user could customize the sub total figure either at the bottom, left, or right or even top of the last cell highlighted. This would make sub totaling many groups of numbers less tedious and faster. I hope my feedback is helpful for your product improvement . Kind Regards Low Seng Kuang Port Klang Malaysia -- A36B58K641 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Relocate Navigation buttons in main form | martyn | Setting Up & Running Reports | 4 | June 7th, 2006 08:41 AM |
Custom functions calculating time arguments Help Desperate | Bill_De | Worksheet Functions | 12 | April 25th, 2006 02:22 AM |
Date & Time | mully | New Users | 4 | May 23rd, 2005 11:56 AM |
How do I get all my Word documents within one Word window | RobJacobs | General Discussion | 2 | April 12th, 2005 03:04 AM |
Get popup menu button to execute VBA function ON A SUBFORM | Ries Spruit | Using Forms | 6 | January 5th, 2005 11:04 AM |