Hi  I have a spreadsheet which has been in use successfully for a year.  The
calculations are mostly simple additions down columns.  In the past I could
enter a new value and it would automatically be included in the total cell at
the bottom of that column.  Now the new value can ...

My company is still running Excel 2000.  Is there a work-around to
getting workday?  For example, if I reference a cell with the date Jan
23 in it, i'd like the formula to tell me how many workdays were in
Jan up to and including that date.  Thanks for your help!!

Does anyone know any more forums for supporting Excel macro coding?  I need
help on macro coding.
Does anyone have any suggestions?
Thank you very much for any suggestions

I have a new product for which I'm trying to display both expected
take up and revenue/profit calculations.
The problem I have is that I'm not sure how to weigh out the adoption
rate.

I have about 300 columns of data.
I have a table with one column with data that needs to be placed somewhere
in those 300 columns depending on the starting date.
What formula should I place in the cells of those 300 columns to tell it to

I have a workbook with 2 worksheets. Sheet A is a data entry sheet (a large
excel list). Sheet B is a daily summary sheet that needs to be populated from
the info stored on Sheet A.
One of the columns in Sheet A contains various dates in no specific order.

Hello and thanks ahead for your help.  What I have is a column on
sheet1 that I enter names ( Column A ). On  sheet17 I have a column
with names in  (A1:A300).  They are username type names so I need them
to be spelled exactly when I enter them on the first sheet. What I need

I have a command button that when clicked I want it to delete the contents
from Sheet1 D1, Sheet1 B3:B100 and Sheet1 D3:D100. Thanks in advance!!!

Thank you for all those that helped me with the count function for running
total. Now I want to take that a little further, using the following
worksheet
         A          B               C         D

I can't figure out why the following keeps happening. I have a list of
data with the date, type of machine, chargable hours, and non-
chargable hours.  Why is it that I can do this:
=SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C

I was wondering if this is possible:
Assume you have two columns of data:  Sales Rep and Quarterly Sales.  The
sales rep field contains only unique values.  What I want to do is to write a
formula that will list the names of each sales rep that has quarterly sales

I want to Look up and match Vendor name (such as "Baker") written in
one cell of current worksheet (Reference Cell) from list of a variety
of vendor names in column of other worksheet (Search column), and
return those in column cells below Reference Cell, without row

Teethless Mama helped me with formula yesterday.
Can someone translate/breakdown the formula please?  See below
Thank you all!
In B1: =COUNTIF($A$1:A1,A1)>1

I have an excell workbook that has 2 sheets i use them for part #'s and i
want to have all of the part #s that have the same part # on bolth sheets to
be put on a new sheet sheet 3 is there a way to do this??

I am not able to change the default in the Options box when I am looking for
a file. It always goes to "sheet". I would like for it to go to "workbook".