I thought it was possible to sum numbers across multiple worksheets within a workbook. For example, you would be able to create a summary worksheet that added...

I need a formula to sum cells which limited to two cells only with highest score **(top 2). example: A B C D E 67 68 50 ...

I need to have a cell on the first sheet in a work book be the referance for anothother cell. The name of suite number and name of tenant is on one wksheet I...

Hello all, I have a sheet that I input account numbers into and the "powers-to-be" would like one character per cell. Can I set set something up so the next...

Need to use Help. I enter a question - doesn't respond.

Is there a function that searches a range for a value 19 and if a value is found then color that cell block gray?

Doe anyone know if there is a way to create page breaks automatically everytime the information in a certain field changes? I use Excel to create timesheet...

I use the advanced sorting option with pivot tables so I can limit the records to the top 20 items in the table. The problem is that I always get more than...

How to calculate a number of days between two dates, exclude the day's off and knowing that working day's should be 6 day's per week ? Thanks a lot

Can you open the file(s) in xl? What version? If you can open a file, try to copy the data into a new workbook. Try to open the file into the newest version...

Hello! Please, I need a formulae to calc next: A B 10 1 2 3 ___ 60 (1*10)+(2*10)+(3*10)

Hi, the best way to explain this problem is to show you the table (attached) and its accompanying format that I would like to migrate the data from. I'm sure...

Hello, Please let me know if any method is there in excell 2000 for cutting a cell from one worksheet and pasting it simultaneously onto other worksheets of...

I have up to 400 rows of data imported into a work sheet coming from a data logging device. The work sheet has functions to test each set of data which forms a...

I need a formula to count the # of rows where the contents of Cell A2 are in column I and column E contains "S".

I'm trying to enter 3 ranges with 3 different ranges into a countif - but can get it to work. Not really sure of the layout. ...

i cannot remove the password protection to open a excel file. i can open the file but cannot unprotect it. can anyone help ?

Aviation Navigation Formula needed for calculating Distance/Heading from Latitude Longitude. I need to calculate distance/heading from hundreds of waypoints...

Hi Have Excel 2002 installed on a Windows 2k Pro machine. When I click in a cell the program acts as though I have held the mouse button down, selecting all...

Hi: Why is it that when I edit a formula (within the formula bar) several times trying to get it to work, (the formula palette appears and gives the answer I...