I have an 8 column by many rows, dynamic named range called "Data". The named
range starts in row 2, column "C". The oldest data is at the top, row 2 and
the most recent data is at the bottom of the named range. "Data" holds
numeric values.

I have a formula that returns a date 30 calendar days from a given date.  
Example, cell A1 has 02/14/08.  I want to add 30 days to this date and find
out what date that is but if that date is a  Saturday or a Sunday, I want the
previous business day which is a Friday.  I want to ...

I am looking for the right formula to use for the following
scenario.   If I had $500,000 in an account at 5% interest per year
over a 15 year period and wanted the ending balance to be $250,000,
how much can I draw out per month and meet the criteria of still

I would like to convert cells formatted as
Tue, 4 Oct 1966 00:00:00
to
10/4/1966

in column A1 i have a beginning balance and in column B2 i want to type in an
amount so column C2 will subtract B2 from A1. =A1-SUM(B2)got that. now in the
next row i want to do the same and so on. the problem i am having is that
when i put in next row, column C3 in rows C4 thru ...

I have this and it works great!!  BUT I need to add a countif into this.  How
do I do that?  I need to break this down to how many per shift per team.
=SUMPRODUCT(--(Sheet4!B1:B20000=A4),--(Sheet4!D1:D20000>=TIME(0,0,0)),--(Sheet4!D1:D20000<=TIME(7,59,59)))
Entry Number    Est. Date ...

i'm sundar if any body know this solution. plz help me
w8 for the result
by
sundar

I have a set of figures 24, 20, 30, 10 that I need to multiply with
eachother. I want the computer to do this for me without me having to
multiply each cell. Is there an equivilant to the Sum function.
I'm really stuck and I need to do this for my boss

I would like to count the number of records returned in a MS Access query.  
All the query does is list the number of appointments made for the last 7
days.  I want Excel to count the number of records that query returns.
Is this possible?

There's a column with results (1.000, 2.000, or 3.000, the Format Cells... is
Text) I would like to replace with 1, 2 or 3.  
Is there a easier way to do it?  I have tried =REPLACEB(A1, 2,4," "), but
it's not working. In the end I had to use Find function : find 3.000 and

In 2007 if you use a conditional sumproduct that refers to another
conditional sumproduct then the parent sumproduct will not calculate (even
with auto on) unless you amend a condition or F2 or save as to a new file
name.

I have two columns, one with cost codes and another the values of those cost
codes....in another worksheet I need to bring in that information. first the
function has to read down the column with the values and if it identifies a
values greater than zero I need the function to ...

Hi all this is my first post.The problem I am having is I am running
small office pool for Nascar.We use 8 starting drivers and a spare.Yo
only get to use your spare if one of your starters doesn't start fo
some reason or other.My question is what formula would I use to to giv

I have a 12 spreadsheets with 1100 lines being given to me from different
people...each person must put a H,L or M in a particular cell, I have a
formula to calculate H,L and M into values.  Example: h=15, L=24, m=30.  On
some of my 12 spreadsheets i have h,L, or M blank which ...

I have a GetPivotData function, as such:
=GETPIVOTDATA("PROPOSED_AMOUNT",$A$1,"ITEM_NUMBER","00424400-01","PROMISED_MONTH","2008_08")
But, I don't want to use a hardcoded ITEM_NUMBER and PROMISED_MONTH .  I
want to use a list of rows for the ITEM_NUMBER and a set of column headers