I am using Excel 2003.
I have one SUMIF function that works just fine. However I wan to add a
second argument to work in conjunction with the first.
Example: =SUMIF (D1:D200, Fred, Totals) works fine. I want to use this

Cell A1 contains the text The date is 2005-11-21.  In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!

I have a range of data example:
Jan 100
Feb 200
Mar 300

I have a large customer list and am looking for duplicates that may be a
variant spelling.
So assume I have two lists like this starting in A1
Cattail Supply

I am trying to enter a number such as 15075, so that the result is 1:50.75
(that is 1 minute 52 seconds and 75 one hundredths of a second).
Thanks in advance biegs!!!

Hi, I need help.I'm sure there is a simple answer,but i can't seem to find
it??!! All i'm trying to do is this:
         A1                                  A8
         25                                   25

I have added the values(text) of 2 columns together by either eg. =a1&""&a2
or =concatenate(a1,a2). I want to use the result of this as the lookup_value
in a vlookup formula but get a #N/A error. Is it possible to use vlookup in
such an instance? If so what can I do to make the ...

enter the name Kim in A7 Name will also come up in A14 on same worksheet

Help!
I'm trying to find a formula that would work out this problem:
Column "A" contains either Y or L and column "B" contains T or any
other letter

Hi, can anyone tell me how to get:
=ROUND(D23*C$42,3)
answer appears in cell E23
to run when some cells are blank please? I have other formula doing similar

Any help?
I'd like to input the real time with date
column a            column b              column c (duration)
11/22/05 9:55    11/22/05 10:00     0:05:00

In Excel 2002, what is the formula to sum a range of cells in worksheet 1 and
display the total in a cell in worksheet 2?

I have a workbook that contains data for each of the months Jan thru Dec for
racing say about 150 cars, 70 cars or less a month, all separated into
monthly worksheets according to cars data (builder, time, ID number, car
name) that ran that month. With each month, there is a car ...

If I type a serial 02/2668 into Excel it gets confused and thinks it is
February in the year 2668. This then confuses me. Is there a way of
straightening the matter.

I have 2 spreadsheets containing names, addresses, d.o.b. etc as column
headings.
I want to identify in the first spreadsheet those records where the data
under the column headings: surname, forename,d.o.b. exactly match any records