I have a document that I think conditional sum has gotten corrupted in.  
Below is an example of my problem.  If I want to add up all of the emails
that Fred has made, I would make start a conditional sum with:
the column to sum:  emails

I have a spreadsheet comprised of entries like this :
726016004084      ALV BAG DANDELION                 United Natural Foods
Inc.
726016004084      ALV BAG DANDELION                 Select Nutrition

Excel 2003 on XP. As header.
This will be even quicker than my last post.
I know I can use the button, or I can go into format cell properties,
but is there a keypress I can use? Ctrl something?

I am bringing data with appointment Times over from another program.  I am
using a TIME formula to subtract 15 minutes off to let person know when to
show for appointment.  
Problem that is occurring is how the time shows.  The time in the cell

This will be an easy one for you experts.
A sheet is called "WK1 1-4apr". At the bottom it has some countif
formulas. N404 is one of these. Naturally, the only thing visible in
the cell is the correctly functioning result.

We just got Microsoft Excel '07 and I'm trying to enter a simple '1-5' type
of data and it keeps converting it to a date. How do I format the cell to
leave what I type alone?

i want to remove the space that is suddenly created by me before row number.
thanks in advance for giving me any help.

Interrupting long calculations in Excel?
Hi all,
I am having a very long calculation in Excel using VBA.
Of course I know I can hit ESC or CTRL+BREAK to interrupt the VBA

I know you can calculate your age in days by
date born A1= 30/09/1978
and          B1= today()
=             A1-B1

I want to select some range dynamically, including multiple selection,
via showing a range selection dialog...
Hopefully there are some dialog functions that I can use...
How to do that in VBA?

I have the names of my worksheets in Col A.  I want to do a COUNTIF
for all these sheets in the same range on every sheet.  Is there some
way I can incorporate the cell with the sheet name into the formula?
Something like:

I'm a newbie in this topic but tried to make sth like that:
Sub CommandButton1_Click()
 Columns("C:C").Select
   For Each Cell in Selection

Is there anyway to replace the new Excel 2007 interface with the old
interface, for example
the menu items "Developer" "Addins", "Review" menus are irrelevant in the
majority of spreadsheet cases we use.

Hi,
Appreciate any help.
I have 3 workbooks created for 3 depts who are responsible in putting in
data monthly. I created a summary workbook that averages (via linking and

I am experiencing problems with excel 2007. My users created various sheets
and protected some columns with password. This work was done with excel
2000/XP/2003. Sometimes they have to copy one sheet of these workbooks to a
new sheet, maintaining columns protection. With excel ...