Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET | Excel Worksheet Functions | |||
function button fx | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions |