How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?

I'm getting too many results when I try to find this myself. Can someone tell me the date that is associated with the 2002 version of Excel.exe? Thanks! I...

We would like to split a field which has sometimes 3,4,5, word in the field the split should be as follows left word shall be copied in 1 cell, right word in...

How to multiply entire colume with constant: For example I have colume A 21 26 28 33 77

Could you kindly assist me with a formula that generate 6 numbers between 1 and 49, without repeating any of the integers. Thanks!

Hello, a very basic question about Excel 2003. Does Excel have a method of letting you use a drop-down menu to select data that's already been entered in a...

I have written an extremely simple function in VBA module for sheet 1 and when I try to use that function in a cell in sheet 1 I get a *Name? error. Has...

I have an excel file with 18000 keywords in it. Some of the lines are up to 4 words per line. How do I sort it so I can only see the lines that have 1 or 2...

I use Excel 2003. I pulled good info off this forum and off other sites referenced within. I can do what I’m trying to do with filters, formulas and...

Allowence $au 2500 Exchange rate 75% Converted rate 1875 How do i do a two input table to calculate rates on a table A B ...

i have opened a new work book, within the book there are 7 sheets (mon, tue,wed etc) on each sheet i have in my first row 12 individual names and my first...

Following data from A1:A7 Sales 12/8/2008 19 22.24 TRUE #DIV/0!

No luck so far ----- Think I just tried that?? And still 00:00 I'm formatting the cells to custom 00:00:00 then in the total box making sure that is the same...

I have a cell range that has 3 different types of cells in it. It's about training, some have date or period when training was completed, some have "due"...

Hi, Today's discovery:- I have a *column* of first names, some of which are duplicates. I did a sort and then I tried to do advanced filter and I ticked...

I just finished a spreadsheet last night that was opened from a flash/jump drive and saved back on it after editing. I took the drive to work and now it is...

I get the opposite effect when I apply this formula... =IF(D75=D76,"Balanced","Error") The answer is "Error", even though the amount is exactly the same in...

What does #DIV/0! mean when it shows up in a cell with a formula? -- Jim S

I get email from friends that send me jokes to open with micro excel and I can't open them why?

i get this error even after pasting in tried and true code. I am trying to paste this code in a workbook I got from someone else. I am not sure why it...