when i copy a formula to another cell it does it correctly, but it also shows
the same value from the copied cell.

How do I write a formula in one worksheet that looks in many other worksheets
and returns the sum of all the values in the last-used cells in a certain
column?

Have spreadsheet...... cells B8:B42 has possibly 6 different compan
names (person    enters date and company they worked with and number o
hours)
A seperate worksheet lists each company and I want to know total hour

I have a column with over 11(K) date entries.  This column grows daily.  I
need a formula that will total the number of entries by month & year
(disregarding the day).

I want both the code and corresponding English translation to appear in the
dropdown box. The codes are in col A, and the translations are in col B.
Under Properites, ListFillRange I have entered: Jobs!A2:B200. Only column A
is shown in the dropdown box. Also, when I select one ...

I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
I know this is easy but i cant think....
I am trying to add 2 different cells from one workbook to 1 cell in
another workbook linked.... Someone make me realize that i need to give

I want to find the difference or elasped time between to times. my
spreadsheet is setup like this:
columnA    columnB     columnc
START      END            difference

I entered the ISError in  my spreadsheet in order to hide the error messages
in my cells. It works great. However, I needed to add more rows and I dragged
the formula down into the cells in the new rows and I get a 0 in these cells.
Could someone explain why this is happening, I ...

I wrote a simple macro and I'd like that macro to be included in every
workbook that I open.
I tried but failed to locate the template to launch a new workbook.
Please help. Thank you.

=IF(S8="Closed","T8","")
I need it to pull the value of T8 - not the actual letter/number T8
Thanks,
Angela

I need help in finding how many rows contain a common series.  Fo
example, if cells A1-A5, B1-B5, and C1-C5 all contain a single-digi
value of either 1, 2, or 3, I need to know what function to use tha
tells me how many rows contain the following series, 2, 1, 2, in tha

When working with Excel 2002, we have set the columns up with headers. After
adding another entry into the spreadsheet, we do a column sort to alphabetize
the column.
We have 5 spreadsheets in the workbook. Three of these, we can sort without

I have rows f figurs
How does I creat a function where I want the average of the minimun+50.
I use an array where I have 200 columns an 7000 rows.
I want a function which invastigates  row by row for minimum and then

Good day,
I am looking for assistance in creating an excel formula.  I have
attempted many different variations of it, but nothing worked.
Basically, I am trying to accomplish this:

=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,FALSE))
                                               col 2       col 3        col
4    col 5     col 6
Absolute Black 12" x 12" tile    $3.80    $3.80        $3.80    $3.61   $3.61