Hi - can comeone help me please
Into B21 I want to add the values of rows B2:B18 where ant of the rowsC2:C18
contain the word "Premier"
tks

I have a B/S on one page and the data resides on another page for all 12
months.
By changing  the month number on the Balance Sheet (B/S) it pulls the data
for that period to the apporpriate accounts.

I have an excel spreadsheet with a column of calculated dollar & cent
amounts. Is there a way to get the calculation (in Excel 2003) to round up to
the nearest nickel increment? or just round to the nearest nickel increment?

was wondering if you could help me, I am trying to do the following:
I've linked a dropdown box to a table with over 4000 entries in it and
need to selectevly bring up a text value from that table, for example:
The drop down menue contains:

A list with 5 different scenarios each have a specific value next to them.
When a dropdown list with all 5 scenarios is opened and one scenario is
selected, the relevant value appears in an adjacent cell.

I don't know how to format a cell so when I enter a number it is not in a
date format.  I want the number to be displayed as minutes, seconds, and 2
decimals.
Thanks in advance

i have a master sheet "master" that shows the latest info from other
worksheets. In my "insurance info" worksheet i have Jan~Dec, all exactly the
same. If i update one of the months i want all other info to update in the
master.i.e. date, policy#, company etc. I have used the MAX ...

Formula trouble:
I have this formula in cell E15: =("LABOR MIDPOINT:
"&CHOOSE(MONTH(D14),"1ST","1ST","1ST","2ND","2ND","2ND","3RD","3RD","3RD","4TH","4TH","4TH")&"
QTR "&(YEAR(D14)+(MONTH(D14)>9)))

Just rec'd speedy and really helpful answers regarding my Q on multiple
criteria, but I should have also asked the correct formula for quantifying
values OTHER THAN  nominated criteria:
1.  if J2:J1180 contains data OTHER than "a", "m", "d", how do I adjust the

I have a table of data that tracks progress across time (down each
row), so that one column (B) will hold a dollar value that will
change. This value is going to serve as a benchmark, so that it is
persistant for some time, then changes as it has been met.

Say if I schedule a particular product to run on the machine for 7.67
hours. What is the probability rate that it will fail between 1 to
7.67? I know I need to get the ALPHA and the BETA to complete my
calculations But I don't know how to get it. I know you could use

I am trying to find a way to link a cell between two worksheets.
Unfortunately copying and pasting the link doesnt work because the data in
the worksheet I am referencing may change rows. For example...
If I have a string in cells A1 and B1 and a numerical Value in C1 and then

10:00 am - 3:30 pm = 5:30 (5 hours and 30 minutes)
How do I convert the 5 hours and 30 minutes to 5.5 hours? I have tried
different formats but have not been able to get it right.
Thanks

I need help with a formula to add a result based on multiple criteria: If a
particular criteria (equal to L14) is met in c2:c1180, then check J2:j1180
for items starting with "m", and/or "n" and add the total quantities
together.  

I have a very old spreadsheet,which appears to have been converted from Lotus
at some point, which will not allow me to type a date in a cell without it
automatically converting it to a formula after I hit ENTER.  This obviously
results in a value which I don't want to see.  I ...