A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Customise the summation function / button



 
 
Thread Tools Display Modes
  #1  
Old June 12th, 2006, 04:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.