Functions

Yearly sum
Any help? I have a column that I want the monthly sum and then the yearly sum, any way to make it easier? A B 1 Jan 2 1 100 3 2 150 4 3 260 5 31 100 6 Sum 610 7 Feb 50 8 1 70 9 90 10 28 100 11 sum 310 12 13 December 14 1 100 15 31 150 16 sum 250 17 Year 1170 (=b6+b11+b16) Thanks in advance ... 16 Mar 2010 11:25

How do I get drop-down list that includes, eg top10
I've seen a drop down list on an excel speardsheet that includes top10, all, blanks, sort ascending and also adds to the list everything entered in the column below. I can create a basic dropdown with data > validation, but how do I include these other features? Thanks ... 16 Mar 2010 06:52

find smallest positive number among datas
How to find the smallest positive number among datas in Excel? ... 16 Mar 2010 22:07

Selecting rows with the same criteria
Dear All, I got a list of data like: A B C D 1 1 ABC 55 Wilson 2 AFD 60 Adams 3 1 DGC 76 Korinth 4 AFV 83 Smith 5 1 URD 45 Hertz .... and I would like the Excel automatically compose table on a new sheet that will show all rows with "1" in A colum... 16 Mar 2010 21:00

Sumproduct for Values over a certain Value eg 0.00
Hi I am using the code below and only want to sum the Values over 0.00, but if I add >0 to this it does the COUNT. Please can you let me know if there is a way of doing this. I have searched and cannot find, maybe I am heading in the wrong direction. =SUMPRODUCT(--('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*... 16 Mar 2010 10:16

Help to create a formulae
I have 5 sheets, Heath, Gary, John and Fred. They go to their sheet Heading: Date Question1 Question2 Question3 They ent 3/3 5 6 1 They enter a date for each monday its filled out. then enter a number between 0 and 10. I have a mastersheet. It has the same heading ... 16 Mar 2010 10:16

rename worksheet tabs
Hello, Maybe you guys can help me. Is there a way rename the worksheet tabs in an Excel file that I've already created? Example... I've already created a fancy Excel report using SSRS. The problem is...SSRS has no way to rename the 10 worksheet tabs to more meaningful names. Any ideas? Thanks! ... 15 Mar 2010 20:44

Main Form - copy exact data from multiple worksheets with live lin
Hello, I've been searching through the forums, but haven't found anything yet. Does anyone know of a way to copy data from multiple worksheets (i.e. 30) to one master form? I do NOT want to summarize the data, I want to replicate it exactly, and have a live link so that if the individual sheets are changed, ... 16 Mar 2010 22:07

Is there a way to use a multiple column array in SUMPRODUCT?
I am attempting to use SUMPRODUCT to pull values froma multiple column spreadsheet and add them together. I am able to get the SUMPRODUCT to work if I am only looking for values in one column, but as soon as I select all columns, the function no longer works. example: column A holds accounts, column B hold... 15 Mar 2010 19:30

cube functions
Hello everyone, in Excel 2007 we have the new cube functions described in this blog for example: http://blogs.msdn.com/excel/archive/2006/02/02/the-excel-12-blog-rides-again-or-cube-functions-part-1.aspx They are much slower when opening or refreshing workbooks compared to regular pivot tables. I'd like... 15 Mar 2010 18:11