I have a table in which I want the total (SUM) of each column--is there a shortcut to inserting the formulas or do I have to do =SUM(A1:A4), =SUM(B1:B4),...

I have a workbook that has 65 worksheets. Each worksheet carries over info from the previous worksheet. How do I insert a line in one sheet and it carry over...

I want to be able to sort (or us in a pivot table) the time portion of dd/mm/yyyy hh:mm formatted cells. To get there, I 'm trying to split the dd/mm/yyy...

Hi everyone, I hope some can help me with this: I need to run a standard deviation on a range within a column that start at CO12 and goes on to dynamically...

I am having trouble using the countif function with an array. I have two columns, one of which is the department column (with department names in each cell)...

I'm trying to figure out a way to automaticcaly assign values to a cell (B3) based on values typed on cell A3. Example: A3 values (typed) = 10%, 30%, 50%,...

I am working with a data set that I have to calculate the % to goal achieved. For this data set though, some of the goals are negaitve growth goals. So for...

Hi How do I have to code the below procedure in a macro properly? ATLN40 = "=Sum(B2:B4)" I want to diplay the result in other cell. I have the following...

Hi all, If I have a serial number (such as 39401) representing a date, and formatting a date) which displays 11/15/2007 in A2, and I want to join that with...

Excel 2003 I want a cell to show a different value depending on whether another cell shows less than, equal to, or more than a range of values. For...

Dear experts, I have one column, C. In this column is a VLOOKUP to another range of cells in another workbook. The Lookup returns whatever comment has been...

I have been unable to find out if this is a limitation in Excel or a mistake on my end. I have a vlookup function, everything is same format, trimmed, etc.......

1) How do I calculate confidence limits? I need confidence limits on density indexes but they themeselves are just calculated as no. observed/km2. Say the...

Hi: I want to set a macro which will work with the sumif formula below. The range (B1:B3 and A1:A3) will be relative every time and would vary the number...

Disregard easlier post. Column references were wrong. Here is corrected post: Using Excel 2000: I have one spreadsheet (titled “evalsecondlang�) that...

I manage a Monthly Sales Log with at least 20 columns of information. I have the listed set-up with Auto-Filter, and many columns have validation lists. I...

Using Excel 2000: I have one spreadsheet (titled “evalsecondlang�) that contains training stats. On another spreadsheet in the same workbook, I need to...

I have a spreadsheet of parts data called Register. On a separate page, I've created a form called OnHold form. Some of the cells in the OnHold form get...

I'm trying to create an if statement with multiple values but it doesn't seem to be working. ie...I have a column that has different values (1,2,3,4,5)....

I am using the offset function on many of my sheets and have made them all identical so that this runs smoothly/dynamically update information. I would now...