Hello, I produced a formula that I need to have expanded. =SUM('2010 Actuals'!E2:INDEX('2010 Actuals'!E2:Q2,MATCH(Sheet1!C5,'2010 Actuals'!E1:Q1,0))) I...

Would appreciate some help!! I have to enter dates and return a date 60 days before the entered date. I am formating the date entered column as...

The follow work fine in seperate...

hi Filtering is not an option :) I have a table that shows skill titles across the columns e3:cz3 and staff names down c4:c103, for each name and skill there...

I am working same work sheet with two columns one is Anticipated Variation cost and the other approved variation with corresponding total. when i enter cost...

Hello, I have a question regarding a pull down. I have two worksheets. In the fist worksheet i have a pull down. In the second worksheet i have about 30...

I am trying to do an if statement on a second sheet, there are three cells that have the same drop down list in it. I tried this bu am getting an...

Hi All, I have a colmun of Codes, of varying lengths that contains Letters at the end of each Code. The letters range from 1 single letter up to a word,...

Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy

I need an Excel 2003 formula that looks at a column and copies each row that contains a variable ("A") to another spreadsheet.

How do I get multiple worksheet table to show at the bottom of my Vista laptop display? The do appear at bottom of my XP desktop display. Thanks.

Hello All, This is on Excel 2007 I would like to see if the array formula below can be changed to check for another criteria. Want this currently does is...

I'm trying to use vlookup to give me a summary of some number throughout a workbook. It has to sum across about 25 worksheets. not all worksheets have the...

I’m doing data validation on a group of cells. At the moment all the names of the employees appear on the drop down list for those cells, but what I need...

I have a block of columns (P-CT) that I need to average but only every 4th one. Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL,...

I am trying to use a countif statement for column A to count the number of times a District is "CAR" PLUS those CAR listings where column N (DAYS) is 499. ...

I am working a drivers logbook formula for 80 hours in 7 days with a reset to zero when a driver has a day off. My problem is when the day off resets the...

I'm attempting to forecast the amount of money spent on the purchase of company cars for the remaining of the fiscal year. (Column 1: Costs of cars and...

I am creating a Game scoresheet and would like to know if I can use a drop down menu in one cell and automatically fill the below cells with players of the...

I have received a template file which has hyperlinks from the summary page to individual detail worksheets. When I am saving the file on my desktop the...