Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Low
 
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET dlc-forbes Excel Worksheet Functions 2 April 9th 06 01:11 PM
function button fx nvrockman Excel Discussion (Misc queries) 1 November 26th 05 07:12 PM
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM


All times are GMT +1. The time now is 07:51 AM.

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

About Us

"It's about Microsoft Excel"