Summing ranges of data in Excel?
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
364953
put all of your numbers in separate fields ie. A1 [15] A2 [20] etc etc.   Then for your total in another field, say B1 put the equation  [A1 + A2 + A3] . now B1 = Sum of the fields you choose
876965
Try using the 'xlswrite' function.  From 'help xlswrite':\n\n  XLSWRITE Stores numeric array or cell array in Excel workbook.\n    [SUCCESS,MESSAGE]=XLSWRITE(FILE,ARRAY,SHEET,RANGE) writes ARRAY to the Excel\n    workbook, FILE, into the area, RANGE in the worksheet specified in SHEET.
459913
Excel has that limitation.\n\nLook into using MS Access instead.
606125
sort the data by cell phone number\n\ninset a column to the right of the number column.\n\nin the first cell, enter this formula:\n=if(a1=a2,1,0)\nwhere "a" refers to the column with the numbers.\n\nhighlight the cell with the formula.  copy it.\npaste is all the way down to the end of the column.\n\nhighlight the column with the formulas.  copy it.  go to the edit menu, choose paste special and choose values.\n\nsort data by the column with the 1s and 0s in it.  anything with a 1 is a duplicate.
626155
Use a flat database file format. One unique value in one column and the rest is employee data. All the data in a contiguous range. This way you can use pivot tables, auto filters, etc. to analyze data.\n\nI would suggest you use the latest version of Excel. Excel 2000 has a limit of 65,536 rows and 256 columns but Excel 2006 (out later this year...MAYBE) has 1,000,000 rows and 16,0000 columns.
995900
It depends on how you have your other amounts organised.\n\nIf you have a column or row that is for periodic end amounts, eg, weekly totals.  You can set up a range for these.  For an example, assume the column A holds the weekly totals.   They start from A1 and finish A52.\n\nCreate a new cell and type this formula, without the quotes:\n'=sum(A1 : A52)'\nThats it.
971578
Nowhere, there is no such calculator. \nPossibly try an excel sheet, where you can alter the information in cells and set parameters.
1135073
If you have a spreadsheet application like Microsoft Excel, then you can place all the items of the buget into the columns or rows of the spreadsheet.  How you have them organised is up to you.\n\nIf you want a sub total, for some items, but not others, etc, you could make a cell.  A cell is the name of the component where you type stuff in.  In this cell, you would want to write something like '=sum(B3:B4)' if you had some buget items in cells B3, and B4.\n\nExample:\n----------------------------------------------\n| - |          A          |          B           | \n| 1 | Mum             |                        |\n| 2 | Income         |                        |\n| 3 | Employment |   $10.00         |\n| 4 | Investments |    $20.00         |\n| 5 | Sub-Total     | =SUM(B3:B4) |\n\n'=SUM(B3:B4)' would be viewed as $30.00\n\nIf you want to make a total, it is the same as making a sub-total, except you would want to use more cells for the sum.\n\nFor more help on the 'sum' function, check the help included with Microsoft Excel under the topic 'sum' or 'function' or both :)
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
275388
It's been  a long time since I used excel but if I remember you just click "insert" then choose "formula" then find   "average" and choose the times you wanted to average by selecting the cells with the times you want to average. \nMake sure all your data is in the same time format and that  you have the right cells selected.\nEdit.\nIf you do not get a satisfactory answer here post this question in the sofware section. Many experts there.
510597
its very simple in the cell where u want to calculate the amount just write down the formula of =sum(cellrangestartsat:cellrangefinished)\nif u have any queries jst give me mail, mokkksh@yahoo.co.in
332491
Try digdb excel add-in\n\nthis is the linke you need
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
1172805
I would use Data Validation and VLOOKUP in Excel to do this.\n\nType in the 2 lists (for convenience lets start in A1) then add a third column:\nSerial#1          Combo#1          =A1\nSerial#2          Combo#2          =A2\nSerial#3          Combo#3          =A3\n\nMake the lists as long as you need. We created the third column for later; it just copies the serial numbers over to simplify things for the VLOOKUP formula.\n\nNow that the data is input we will need to create a drop-down menu. Since the data is in columns A-C, click in E1 to select the cell and click Data | Validation… In the Allow box choose List and type the range for the combinations in the Source: field (in our example: A1:A3). Now, click on F1 and type this formula:\n=VLOOKUP(E1,A1:B3,2,FALSE)\nIn the parentheses you will have this data: \n-E1 is the criteria you will look up in the array.\n-A1:B3 is the array where the data resides (remember this is from the example, yours will be longer).\n-2 in our formula tells VLOOKUP to pull the data in the 2nd column that matches our criteria from the 1st column.\n-False tells VLOOKUP to look for an exact match.\n\nWe have now created the Serial Number lookup that returns the proper Combination. To lookup the Serial Number from the Combination, we just do the steps again.\n\nClick in E2, choose Data | Validation… Again, in the Allow field choose List, but this time we need the combinations in the drop-down (B1:B3); click OK. The formula for F2 is almost the same:\n=VLOOKUP(E2,B1:C3,2,FALSE)\nThe only differences is that the criteria and array are shifted; the criteria down one row and the array over one column.\n\nIf you wish to hide the rows that contain the array, just right-click on the column headings and choose hide.
391107
USe the function "CountIF"\n\ne-mail me for more details
572733
Please check out this site it gives averything you want on VBA.\n\nwww.functionx.com