I need help - I actually am trying to do two separate functions, but I
think the formula should be similar for both.
#1:  I am trying to sum a column if two cells in each row are equal.
For example:

Does anyone know how to display the month only for date format?
such as 26 Sep, 2006, it displays Sep only.
Thank you for any suggestion
Eric

Hello From Steved
below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
I need a total for product P how do I do this Please

  I have a dynamic name range in a column, say colA with name Test from A7
to the end of the column.  When I set A5 = sum(test), it always gives me 0.  
Any idea why?
Thanks,

I have marathon times in hh:mm:ss format and want to get the miles/hour
speed, where miles is 26.2.  How do I do that?  I have Excel 2003.

Spreadsheet tracks race times for cross country races and needs to be able to
calculate improvement time in mm:ss (or zero if less than previous race).  
Also,it would be nice to be able to enter times without using colons or have
to reference the field as h:mm:ss. The race result ...

I need to write a 3D formula averaging January Sales for B3:B8 linking
between 3 worksheets called Sales 2002, Sales 2003, Sales 2004.  Please help
me.

I have colomn with start date(Column A), Column C = duration Column B =
Column a + Column C
I would like exclude Saturday and Sunday of the week
How can I do That?

This box is in my way when using @sum, but I am unable to find how to hide it.
how do you hide SUM(number1,[number2],...

How do I make a macro to print e.g. sheet 2, sheet 3 or sheet 100 by clicking
a button on sheet 1?

I tried to callculate the difference between 14.02.1980 and 21.02.1985, but
excel does not give the exact difference in years, months and days.
I used the formula
=DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months,

I posted on the "microsoft.public.excel" group, I am hoping someone
different is reading this group.
Thanks
XP Pro

I am trying to delete characters in a Excel cell right of the "!" symbol. Is
there a function that can be used to do that

I need to make a workbook with 52 pages (1 for each week) that looks at the
previous page and updates accordingly.  Right now, when I create a new page I
have been using find/replace to replace all page references to the correct
page.  This is very time consuming and I am hoping ...

How to give same name to a cell in multiple sheets at the same time
I did try to group all the sheet at the sametime and name the cell, but it
did not work, each of my sheet have different name?
Need Help!