On column A, there are numbers designated to names on col B.
Col A   Col B    Col C  Col D
1        aaa        bbb      2
2       bbb        ddd       4

Hey all,
Basically I am trying to work out a sum. I have a grid with distances
between cities, and I want to sum the ones I indicate by making bold.
Any ideas?

Excel 2003
Menu:      Insert  =>  Name  =>  Define:
N = 20
O = 30

WHAT FORMULAS IS USED TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?

My lookup table is like this:
9:30:55 AM      440.43
9:30:56 AM      440.22
9:30:57 AM      440.03

Hello Forum
Hope you can help me solve this one.
I pack fruit in 200 and 40o gram cartons. This is pure fruit with the
waste taken off.

I am trying to use the Data Table function, and the outputs are all the same
value even though the variables are changing.  I succesfully use data tables
all the time, and have done nothing differently this time.  Any
troubleshooting advice would be appreciated.

I have numbers arranged in a column that I need to put in another application
by copy and paste. The other app only accepts data arranged in a row with a
maximum of 25 at a time. How do I convert the column into a row in excel so I
can copy and paste in a group of 25 instead of ...

hey guys,
This seems relatively simple but I just can't nail it down!
I have 5000+ entries of dates in format 12/17/2001 etc. I need to
specifically count all those above the date 1/1/2002. Is there any way

-*First problem:*-
let's say i have a cell A1 with =today()
Why can't i use =datevalue(A1) ? or =datevalue(today()) ?
I would like to use it to count the days between a day

I want to protect the cells with formulas, but still allow other users to use
the worksheet. Please Help

I have the following array that uses a date to lookup my array (i.e. in E4).
=VLOOKUP(E4,'e1'!H:I,2,1)
I want to modify this so that it looksup the value less that today. For
example if today is the 25th April 2006 it would return 24th April 2006.

I want to define a range using values in two cells. Let's say cell B40
contains information about the cell at which the range should start (it says
for example: cell B101) and cell B56 contains information about the cell at
which the range should stop (it says for example: cell ...

I have the following Excel Spreadsheet setup:
Col 1         Col 2                          Col 3
94    LAMPKIN, Louis William   
    will                   3/15/04

I have the following formula that I am trying to use but the result is #VALUE:
=SUMIF(Sheet1:Sheet9!B1,"PMI",Sheet1:Sheet9!A3)
The formula should look in cell B1 of each sheet and if it is equal to "PMI"
sum of the value in cell A3 in each sheet.