I've been using the following formula from the xldynamic website detailing
sumproduct usage as a base for retrieving uniqe instances in a data series.  
I've been trying to modify the formula to allow me to utilize one additional
criteria.

I use a large SS that has expiry dates in column H for "live" jobs. I have a
stats screen that counts the amount of entries that are beyond this date
using a countif statement. For example: =countif('Sheetname'!H:H,today())-1)
I repeat this upto -7 and that is excels limit on the ...

I have a formula that will will search and give me the totals for the month
and text listed in specific cells:
=SUMPRODUCT(--(MONTH(O31:O1001)=MONTH(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))
Is it possible to modify the month portion of this formula to check for a

How can I calculate the cube root of a number?  Is there a formula for this?
Thanks!

Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Thank you!

Given I have a cell with a person's date of birth (mm/dd/yyyy) can I
have another cell perform a function where it produces the person's
current age based on their DOB?

I have a worksheet setup with 5 tabs.  On 3 of the tabs I do not want to be
able to type "123" into any of the cells.  Can I write a pop-up or function
for these three tabs within the worksheet?

I have never written an Excel Macro.  Where do I start?  
I want to take data from one spreadsheet, and insert it into another on a
monthly and cumulative basis.  I have version 2000.
Mac

I want to be able to type 1 and display .01, then type 1. and get 1.00
How do I accomplish this?

I wish to copy cells containing formula to another cell but when I paste
I want the
the formula I to have the same references as the original cell

How do I set up an "AutoNumber" function in an Excel spreadsheet?  I need to
sequentially number sheets from a PO template I created.

I am working with one document that has four worksheets.  Each worksheet
shows different pieces of information about a client.  However, to save time,
I have "pulled through" the names from the first worksheet (using the =
command in subsequent worksheets and clicking in the box ...

I have 3 workbooks linked together in this order
2 linked to lookup 1 database workbook of 1 worksheet
then 1 of the 2 others linked to the other. These 2 have multiple
worksheets with lots of formulae in each for comparing price results

I have a workbook athat was authored by someone else and sent to me for
editing that replicates itself when opened.  At this point I have 5 versions
that open up at the same time when I open up the file.  What causes that and
how do I prevent it from happening in the future.

I am trying to enter data that was collected on different dates/times and
calculate the duration of the entire data collection.  How can I enter the
dates and time such that I can calculate the duration?  I am using Excel 2000