auto sum function

I just realized my final sum changes if I use the "sort 
ascending" function.....

How do I fix this ?

thank u
0
anonymous (74722)
9/6/2004 10:02:43 AM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
502 Views

Similar Articles

[PageSpeed] 57

Hi
where is your sum formula located?

-- 
Regards
Frank Kabel
Frankfurt, Germany


anonymous@discussions.microsoft.com wrote:
> I just realized my final sum changes if I use the "sort
> ascending" function.....
> 
> How do I fix this ?
> 
> thank u
0
frank.kabel (11126)
9/6/2004 10:37:36 AM
Down a colum

But also, i just found out info changes on each lines when 
i use the "sort ascending" tool...

>-----Original Message-----
>Hi
>where is your sum formula located?
>
>-- 
>Regards
>Frank Kabel
>Frankfurt, Germany
>
>
>anonymous@discussions.microsoft.com wrote:
>> I just realized my final sum changes if I use the "sort
>> ascending" function.....
>> 
>> How do I fix this ?
>> 
>> thank u
>.
>
0
anonymous (74722)
9/6/2004 11:22:35 AM
Anytime you sort - you need to make sure you are sorting the proper range.
Say you have a table with headers on Row 2 starting in column D thru column
J.
Your data is in cells D3:J20;  Row 21 in columns H, I, and J has
=sum(h3:h20)...
Before performing a sort - click anywhere INSIDE the table (click on any
cell containing
your data - Excel guesses at the "table-range capable of being sorted" and
often times you can go ahead and proceed,  but I prefer to not leave
"things" open to chance, so I
instruct or tell Excel what my range is (and in your case example above - by
performing  the following...)  Click on D2 and drag the mouse over to column
J then down to Row 20 highlighting D2:J20 or making it the current
selection;
Then go to the menu select Data, sort - look carefully at the settings excel
has automatically assigned (this is your job!!) - note that the button at
the bottom "header-row" is checked..
Perform the sort.
Everything ***all your data*** should  stay together/intact only sorted as
you wanted;
even the sums should be fine as they were "omitted" from the sort..
HTH
Jim May




<anonymous@discussions.microsoft.com> wrote in message
news:058c01c49403$cef14e70$a401280a@phx.gbl...
> Down a colum
>
> But also, i just found out info changes on each lines when
> i use the "sort ascending" tool...
>
> >-----Original Message-----
> >Hi
> >where is your sum formula located?
> >
> >-- 
> >Regards
> >Frank Kabel
> >Frankfurt, Germany
> >
> >
> >anonymous@discussions.microsoft.com wrote:
> >> I just realized my final sum changes if I use the "sort
> >> ascending" function.....
> >>
> >> How do I fix this ?
> >>
> >> thank u
> >.
> >


0
jmay (696)
9/6/2004 12:19:48 PM
Nothing changes, can't I just tell Excell to remember each 
cells/line it has included when I clicked on "sum". In my 
sheet, each row has 3 different prices and my final totals 
change if I use the tool "sort ascending" ?

>-----Original Message-----
>Anytime you sort - you need to make sure you are sorting 
the proper range.
>Say you have a table with headers on Row 2 starting in 
column D thru column
>J.
>Your data is in cells D3:J20;  Row 21 in columns H, I, 
and J has
>=sum(h3:h20)...
>Before performing a sort - click anywhere INSIDE the 
table (click on any
>cell containing
>your data - Excel guesses at the "table-range capable of 
being sorted" and
>often times you can go ahead and proceed,  but I prefer 
to not leave
>"things" open to chance, so I
>instruct or tell Excel what my range is (and in your case 
example above - by
>performing  the following...)  Click on D2 and drag the 
mouse over to column
>J then down to Row 20 highlighting D2:J20 or making it 
the current
>selection;
>Then go to the menu select Data, sort - look carefully at 
the settings excel
>has automatically assigned (this is your job!!) - note 
that the button at
>the bottom "header-row" is checked..
>Perform the sort.
>Everything ***all your data*** should  stay 
together/intact only sorted as
>you wanted;
>even the sums should be fine as they were "omitted" from 
the sort..
>HTH
>Jim May
>
>
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:058c01c49403$cef14e70$a401280a@phx.gbl...
>> Down a colum
>>
>> But also, i just found out info changes on each lines 
when
>> i use the "sort ascending" tool...
>>
>> >-----Original Message-----
>> >Hi
>> >where is your sum formula located?
>> >
>> >-- 
>> >Regards
>> >Frank Kabel
>> >Frankfurt, Germany
>> >
>> >
>> >anonymous@discussions.microsoft.com wrote:
>> >> I just realized my final sum changes if I use 
the "sort
>> >> ascending" function.....
>> >>
>> >> How do I fix this ?
>> >>
>> >> thank u
>> >.
>> >
>
>
>.
>
0
anonymous (74722)
9/6/2004 1:51:57 PM
Reply:

Similar Artilces:

Time functions #2
Hi, I have to do some time calculations and I have a formula that outputs in minutes and I have to subtract a standard time to this number of minutes. For example, I have 8:00 AM in one cell and 20.68 minutes on an other cell. The output that I am expecting is 7:39 AM. Does anybody know how to bring an output like that by subtracting the minutes? Please help. Thanks With 8:00 AM in A1 and 20.68 in B1, use this formula =A1-B1/(24*60) Why does it work? Because Excel stores time as a fraction of a day. We convert minutes to days by dividing by 24*60 (24 hr/day and 60 min/hr) You could just u...

Sums and percentages in reports
I have the following field in report's detail area: =Count([Cause]=1) (where 1 refers to a row of a table's dropdown) at the report footer I have the following sum for that column: =Sum(Abs([Cause]=1)) with the Runnin Sum - Over All. The calculation comes out correc so I'm assuming the formulas are correct. However, when I try to get a Percentage by deviding the field formula with the footer formula I don't get the correct answer. Can someone help me with this formula? You have told us what you attempted but it isn't clear what you want to accomplish. Your expres...

Help with auto height of rows
Hello, I've got Excel 2002. Spreadsheet has over 3400 rows and 6 columns. No merged cells. All fonts are Arial size 10. The first 1809 rows are set to a height of '15.00 (20 pixels)' and the remaining rows are set to '12.75 (17 pixels)'. I've tried selecting all rows and then double clicking on a divider bar to get them all to adjust to auto height, but they stay at the heights listed. I want them all to be at the 12.75 (17 pixels) height when you do the auto height adjustment. Why won't this work on this spreadsheet? Thanks. Mark Nevermind - I fig...

Server-Wide Auto-Reply / Address Change Notice
We are in the process of changing domains as far as email/web addresses are concerned and I wonder if it would be possible to have Exchange reply for each user with a message stating something like, "This is an automated reply letting you know that the email address for User Smith is now usmith@fakedomain.org." I realize that each user could create a rule in Outlook... but we would need the rules to apply for a long period of time and that could be very annoying for senders... getting hit with constant auto-replies. Even if it would be possible for a user to create a rule th...

Auto Filling Fields in Current Record from Previous Record
Hello, I have looked through posts related to Auto-Filling a field from a previous record but am still a little unsure of how to do things. What I would like to do is auto fill a field in the current record with one from a different field in a previous record. What I have is a form that records "engine hours" and "tonnes moved" for a piece of equipment. The operator will record the staring hours and tonnes (at the start of a day) and the hours and tonnes at the end of the day. So in the database, I would like the "Starting Hours" and "Starting Tonnes"...

Adding functionality to MS Outlook Express
Hi, I am looking for help to integrate anti-spam open source programs with MS Outlook Express :- - SpamPal - http://www.spampal.org/ - Spamato - http://www.spamato.net/ The problem is to provide a library that will facilitate this. I have read the MSDN Messaging and Collaboration documentation which gives the ability to get notifications of new messages and to access message folders :- http://msdn2.microsoft.com/en-gb/library/ms709546.aspx The next need is to add a toolbar (with buttons for SPAM/NOSPAM) and to detect what messages are selected in the message window. The MSOE...

How do I set up an out of office auto response?
Hi: I'm a new user to Outlook and I was trying to initiate an "out of office response"/auto reply for one of my colleagues. Can you help me out? Thank you so much. JenniferC <JenniferC@discussions.microsoft.com> wrote: > Hi: > I'm a new user to Outlook and I was trying to initiate an "out of > office response"/auto reply for one of my colleagues. Can you help > me out? Thank you so much. http://www.slipstick.com/rules/autoreply.htm -- Brian Tillman Yet another stupid question what is the OOA & how do I enable it? "Brian Tillman&qu...

If Function Possibilities
Is there a way to set up in a cell A1, something like... If the formula used in cell B1 is "here I would type the actual formula in," then display the words "works," else display "mistake" ? -- rheller ------------------------------------------------------------------------ rheller's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24081 View this thread: http://www.excelforum.com/showthread.php?threadid=377045 That's a pretty cryptic post. Do you mean: In A1: =IF(B1=n,"Works","Mistake") where 'n...

Inserted rows, now need Counta function
Hi I've got a data dump. I've figured out how to insert a blank row after a change in name in column A and insert "Total" - so... bill.... bill.... bill Total - bob.... bob.... bob.... bob Total - What I need in column C next to total is to insert the COUNTA function for each person. Any ideas? cheers You say your code inserts a blank row after a change in name and inserts "Total", but your example doesn't show this. Can you post the code you are using to do your "insert"? It will probably be easier to handle the ...

Writing Access functions
I am an old FoxPro programmer (but have been out of programming for many years) and I have been through the Access basics that I have been able to find on line. So I can create tables, forms enter data the basics. I am learning VBA no problem there. Now I want to write some functions. I would like to write one function that is passed an ID and returns the last name of the person having that ID. I would like to write this function in two ways: 1. Connect to a table in my DB find the ID and return the name 2. Have the function perform a query that returns a record set from which t...

reading file name from folder function
I am using Access 97. Just wonder if there is a fuction which can read all the file name from a folder and put it to a column in a table. Please let me know. Thanks. Hi. >I am using Access 97. Just wonder if there is a fuction which can read all >the file name from a folder and put it to a column in a table. Please see the getFileInfo( ) function in the tip, "How to compare the contents of two directories," on the following Web page for an example: http://www.access.qbuilt.com/html/vba1.html HTH. Gunny See http://www.QBuilt.com for all your database needs. See http...

Function Keys in Excel
Can someone please tell me what the F2 key does in Excel 2000? I have a column of data which has been copied from Access 2000 into an Excel 2000 sheet. It is numeric data and when I use the "Countif" function on this data, it doesn't calculate. However, if I press the "F2" function key in any of the cells, something happens to the data so that the "countif" function recoginises it. Can anyone explain what is happening here? Thank you. -- LPS F2 allows you to edit directly in the cell, do you have calculations set to automatic under tools>calcul...

I am trying to get access to display leading zeros and auto numbe
we use a sequential number system that begins new each month but we need it to hold 4 places 0001, 0002. etc. I would like to know if Access will do this. "Donna" <Donna@discussions.microsoft.com> wrote in message news:484176CC-EFDE-48BB-BF18-C5BEFD695710@microsoft.com... > we use a sequential number system that begins new each month but we need > it > to hold 4 places 0001, 0002. etc. I would like to know if Access will do > this. Yes, but ... You can't use the built-in autonumber field to do what you want. Therefore you'll need so...

faq: type of CArray as function parameter create errors
Hi, class CMyPoint { public: long x; long y; CArray<int,int&> m_intSegmentNo; CMyPoint(); virtual ~CMyPoint(); CMyPoint(const long &xx, const long &yy); CMyPoint(const CMyPoint &cmpt); CMyPoint(const CPoint &cpt); CMyPoint& operator = (const CMyPoint &assmypt); CMyPoint& operator = (const CPoint &asspt); bool operator == (const CMyPoint &rmypt);//const CMyPoint &lmypt, bool operator != (const CMyPoint &rmypt);//const CMyPoint &lmypt, }; .... class CSegment { public: CList<CMyPoint,CMyPoint&> m_PointList; CSeg...

Function for convertion of leters doesn't work.
I'm using function LOWER to convert string i my table on small size but Access gives me a message that the function is not defined.Please, do you know another function? MS Access does not have a LOWER function. Try LCase() instead. -- Cheryl Fischer Law/Sys Associates Houston, TX "Stenli" <svet2000@seznam.cz> wrote in message news:10b201c3626e$b613a050$a301280a@phx.gbl... > I'm using function LOWER to convert string i my table on > small size but Access gives me a message that the function > is not defined.Please, do you know another function? ...

Report Writer Functions #2
Where can I find instructions and examples on the various report writer functions? I've installed the SDK but I don't see anything there. The Report Writer On-line manual (Help - Printable Manuals - Reporting - Report Writer) has a fairly good description of the functions in Chapter 6. Do you look there or is there a specific function that you did not find there for which you are searching? "Elaine" wrote: > Where can I find instructions and examples on the various report writer > functions? I've installed the SDK but I don't see anything there. Hi El...

Public Function not running
Hey, I have a public function that I call from a cell. The function is: Public Function QuitTime(strQuitTime As String) As Date Dim strHour, strMin As String Dim intHour, intMin As Integer Dim dtTime As Date strHour = Left(strQuitTime, 2) strMin = Right(strQuitTime, 2) dtTime = strHour & ":" & strMin dtTime = dtTime + Range("MainSheet!B2") ' this cell contains the value today() QuitTime = dtTime End Function Anyway, I run a vlookup on this array from another sheet and when ever i run that vlookup, it makes all the cells in th...

Question on "Value" function
In trying to use Excel to help solve a mathematical puzzle, I would like to calculate the result of applying the mathematical operator in one cell to the numbers in two other cells. Example: A1 contains 2, B1 contains +, C1 contains 3. In D1, create a formula that will give the result of 2 + 3, i.e. 5. I have tried (among many other attempts) =VALUE(CONCATENATE(A1, B1, C1)), but it gives me a #VALUE! error. What am I missing? Hi this is not possible without using VBA. try the following UDF: Public Function my_calculate(op1 As Range, operand As Range, op2 As Range) my_calculate = Ap...

Auto Empty Deleted Items on Exit OR after X days or X Items accumulated?
In Outlook 2003 is there a way to Auto Empty the Deleted Items Folder, either on Exit OR after X days since deletion or when X number of Items accumulated? -- "J. J." Go to "Tools" : "Options" : "Other" First option is "Empty Deleted Items folder upon exiting" You can set it to delete after x number of days for certain e-mail account types. Go to: "Tools" : "E-Mail Accounts" : Select, "View or change e-mail accounts" Select account to chnage and click "Change..." : Click "More Settings" Se...

sum items in a table based on description
I am interested in summing items is a table based on their description. Is there a formula that will add items together from column based on the contents in another cell reference in the same row? I know a pivot table will do this with some restrictions in the table design. You can use sumif if there is onbly one condition Assume you want to sum values in column C where column B is "x" =SUMIF(B2:B500,"x",C2:C500) Regards, Peo Sjoblom "Hrider" <hrider@yahoo.com> wrote in message news:ejggYE$MFHA.3328@TK2MSFTNGP14.phx.gbl... >I am interested ...

Missing engineering functions
In an earlier version of Excel, I had "engineering functions" like =dec2hex and =hex2dec. Not, in Excel 2003, I see them in the "help files' but not in my list of available formulas. How do I get them to work in Excel 2003? Thanks in advance, Geoff Waters Glendale, CA Geoff, I don't have Excel 2003, but you should be able to go to Tools | Add-ins and check mark "Analysis Took Pak" in the list that appears. Regards, Jim Cone San Francisco, CA "Geoff" <grw888@hotmail.com> wrote in message news:zwfIc.299$Qu5.238@newsread2.news.pas.earthli...

Read Receipt Function in outlook
The read receipt option is no longer working in Outlook Small Business Edition for XP 2002. I have not made any recent changes to my outlook setup. Does anyone know how I can trouble shoot this? ...

Outlook today function
When I click on the customize outlook today button nothing happens. What should I do. OL2000: You Cannot Customize Outlook Today After You Install Critical Update 813489 for Internet Explorer: http://support.microsoft.com/default.aspx?scid=kb;EN-US;820575 You can edit the registry to make changes to Outlook Today. http://www.outlook-tips.net/howto/oltoday.htm -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://ww...

Auto delete stopped functioning in Outlook 2000
Hi, I have a single install on a user PC which although the option to auto empty the waste bin is checked it is not deleting or even asking whether she is sure she wants to delete. Advice appreciated, Sam ...

Auto copy emails btw 2 mailboxs
Hi All, I have 2 email accts A , B. 1)What ever sent to acct A will auto copy to Inbox B. 2)What ever sent from acct A will auto copy to Sent Items Box B. How do I define this email rule in MS exchange server? Thanks & Regards, Steve 1) In AD Users and Computers, select the profile properties, go to the Exchange General tab and select Delivery Options - here you can specify mailbox B to get a copy. 2) not sure if this is possible. S. <foozhiqin@gmail.com> wrote in message news:1116902957.014076.300440@g44g2000cwa.googlegroups.com... > Hi All, > > I have 2 email...