this is the formula that I've used before but not needing dates so I'm having
trouble.
=SUMPRODUCT(--('PO Numbers'!$K$4:$K$240=17407),--('PO
Numbers'!$A$4:$A$240=1/0/7),'PO Numbers'!$J$4:$J$240)

This is a strange one.  I have an Excel workbook that was created in
Excel XP.  It has 4 total sheets -- 2 with data that's calculated, and
2 that are just for data lookups.  Most of the functions employed are
standard... included in Excel's library.  It also uses 2 custom

I'm not sure if this is an excel function or an access function.  (I don't
know Access - however I'm fairly well versed at Excel).  
My company has a separate Excel spreadsheet with data for each client.  We'd
like to continually update the data in the client specific spreadsheet ...

I know sorting puts all true blank cells go to the bottom of the list.
My question is:
Is it possible to make blank cells caused by formulae such as
IF(logical_test,value_if_true,"") also do the same?

My current worksheet only uses Rows 1-35 and columns A-H.  I want to be able
to grey out or make all other rows or columns disappear so that you don't see
them and when you scan down, you are not suddenly on row 345.  I know I've
seen this on other spreadsheets but I'm not sure ...

I have two data validation list cells - cell $D$15 (has the option of blank
or "affiliate") and cell $E$72 (has the option of blank or 1% - 10%).  
When cell $D$15 is blank, there are no restrictions on cell $E$72.  However,
when cell $D$15 is "affiliate", I want cell $E$72 to ...

We have problems with a network's user. The Excel installed on this machine
create tmp files and never are deleted, the user have to delete it manually.
The aspect of these files is: name.xls~nametmp.TMP.
Could somebody help me, please?

Excel 2002
Scenario: I want to calculate when I begin to make money on an investment.
Invest $10.000, the commission to set up the fund is $900-, thus my starting
point is $9100-. I want to input the current investment balance and see by

Excel 2002 SP3
Win XP Pro
Hi,
I need to do a flow chart but need to change the background color of

Does anyone know how to create data tables in a sheet other than the
sheet containing the input data? Someone showed me the trick a long
time ago and it has escaped my mind.
Thanks in advance for any clues or complete solution.

I am new to excel and I am trying to find out how to do percentages.  One of
my questions is find out 25% of 196 and I am just drawing a blank!

When I use find and replase to edit multiple hyperlinks in a Excel sheet
(linking to another workbook and sheet1) to link to sheet2 instead, the
hyperlink changes on screen but proforms exactly the same (links to sheet1).  
How do I get to do what I want?

How do I add a page within an Excel document?  I want to copy figures onto
another page and flick between the two, rather than open a second document.

I have a range of calculated values and want to display the smallest
value in an adjacent cell. However, some of the cells (correctly)
return #DIV/0! errors and, as the help file explains, the MIN function
subsequently returns this same error. Can anyone think of a way of

I'm trying to analyse an excel sheet and it's not going well!!!
Our running club has just hosted a race and I'm trying to do some analysis
on the entrants and create a report sheet..  Here is a rough outline of the
sheet.