I am having difficulty wrapping my brain around this one.
I have this equation:
=SUMPRODUCT(--($B$43:$B$7577>=DATE(YEAR($B$29),MONTH($B$29),DAY($B$29)-B$31)),--($F$43:$F$7577="Open"))
The date of an activity is in B43:B7557 and values of Open are in F43:F7577

I would like the color orange for filling cells but it is not an option
(excel 2003).  Is it possible to download more colors from somewhere?
Thanks

Hi all I am trying to figure out how to name a cell if it equals to
zero, forinstance =SUM(C22)*44.5 but if it equals zero I want to
display the words "Total Times 44.5"
I am also trying to center two cells or have one cell read =TODAY() But

Hi,
I want to lock&hide some cells which contain formula, First I select the
cells I want people to access(change valuves) and choose
fromat/cells/protection&untick locked, then choose tools/protection/protect

I have a fairly complex file that has mulitple links to other files. My
problem is some of these links work fine and some of them don't. The ones
that return a #REF error work fine when the file they are linked to is open,
but not if that file is not open. It's weird because ...

I have a spreadsheet of questions - about 250 in total. The user is supposed
to select their answer from a drop down box. There are eleven possible
answers to the various questions AND the drop down boxes have different
combinations of of the eleven answers. For instance, in some ...

I have a good formula in a cell, working just fine.  It is:
=NETWORKDAYS(K29,N29,'C:\My Documents\Projects\Canadian
Non-Workdays.xls'!NonWorkDays2006)-1 which gives the number of days
In another cell I have this formula, which also works just fine:

How do I set spreadsheet to "open for editing" automatically?

I am trying to add and/or subtract columns reading from right to left.  I
cannot figure it out - please help.

I'm trying to run a sumif function from two different words in the same row
and then sum the range three cells to the right.
Any ideas?

I am working with a fairly large spreadsheet I inherited that contains the
ROUND function in several cells.  Two questions: (1) How do I remove the
rounding function w/o disturbing the formula. (2) Is there a quick way to
remove it w/o going into every cell?

(hmmm, I posted a message a few hours ago, but it doesn't seem to
have been posted, so I guess I'll try again...)
I would like to use Harlan Grove's PULL function to reference data in
a potentially-closed workbook.  (I do not want to use direct links,

In my Worksheet I have 80 columns (80) numbers with over 100 rows.
All numbers are mixed.
I picked 20 numbers and mixed them using a special algorithm.
My conditional formating formula picks(marks) 20 numbers in each row.

I try to make edits an Excel object pasted into Word, which was inserted
using the  Paste Special command  -- but I received a message "This object is
corrupt or is no longer available".
Why does this happen -- what can I do to repair?

Hello everyone, I have a 'jobs in progress' worksheet and I'm trying to
sum the total materials by work code.
column F has codes:                                 Column AU has
material totals: