I'm facing the following situation:
- I've got named ranges using an offset function f.ex.
Range1_Sheet1=offset(...), Range1_Sheet2=offset(...),etc pointing to a range
of numbers.  (The size and position of these range depend on the content of

I have a quantity that must be multiplied by a cumulative % factor at each
period over a time series. At each period of this time series I add another
quantity that must then be multiplied by the same series of factors starting
from the beginning. The resulting list of factored ...

I need a formula that calculates interest to receive if at least 4 of 5
shares are higher at determination date then subscription date. I tried with
=if(and/or, but it is not enough because those logical operators applies to
all shares.

5 column spreadsheet...Want to sort by col A while keeping B-E attached to
original col A...
I originally set this up a few years ago, and thought I was doing the right
thing when formatting each cell....

I found the template for the Employee Attendance Record, and it's the one I
need, but I also need to add a column for "accrued vacation days" (monthly).  
How do I do that?

Hi, I know how to do Data Validation but I'm coming across a problem that I'm
really stumped with. I've looked around to see if anyone else has had this
problem but can't find any solutions at the moment - especially as "INDIRECT"
doesn't seem to be working for me in this ...

i am working in a spreadsheet that has usage by week.  what i want is for it
to look at the cells and give me the highest usage week.
Example
A1 = 50

I have been tasked with moving one persons Excel macros on one computer
resource to another persons computer resource.  Being unfamiliar with this
task or macros, can anyone offer me suggestions/recommendations/how to steps?
Any and all assistance is greatly appreciated.

hello how's everbody doing?
look, i have a sheet in excel 2003, i created a check format in that sheet,
i programmed it with the "spellnumber" formula and the code in VBA, that,
when i type a number in a cell, in another cell, gives me the result but in

I'm trying to count the number of values, within a column over multiple rows,
that fall within a range.  I can do that with the COUNTIF function as follows:
=COUNTIF(Q6:Q53,"<31")
However, now I want to extend that to break of the counts by month.  I have

In a Pivot table of mine, there is a field called StatusHeader.  The
values can be Submitted, Closed Out, Paid, Reopened.
I need to create a custom calculation now called Net Closed Out, which
would be Closed Out - Reopened.

I'm trying to do the following:
ColA   ColB
9    SUMIFS(Data!I:I,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)
10   SUMIFS(Data!J:J,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)

I have a spreadsheet with numerous columns of data containing dates linked
from other spreadsheets.  I'm using the "counta" to count the rows containing
data in each column, but my problem is every row is being counted whether it
contains data or is blank.  

I am trying to figure out how I can subtract 2 times:  day 1=7:20 am and day
2 = 14:45  answer should be 31:25.  I need to use the result when averaging
the column.  Formula used is : =IF(COUNT(N50,S50)=2,MOD(S50-N50,1),"")
giving me 7:35 which would be correct if within 24 hrs.  ...

I am trying to use the averageifs function to determine the average
temperature given a specific date.  When referenceing the dates to useI am
linking to another cell.  Apperently it think the cell link is text, not a
link.  how can I fix this...Ex