I'm using the Formula below to give me a static count of numeric values that
fall within a specified range; say 50-75 inclusive. These ranges are housed
in cell X$1. The Named Range "Data" is a dynamic 9 column range spanning many
rows. Named Range "Data" is defined as

I have a figure in one cell (cell c1) which is linked to another input cell
(cell c2). However when I change the cell c2, the result in c1 doesn't
change. I have set the Calculations under Tools => Options as Automatic,
could there be other reasons which triggered the ...

I've never had this happen before.  I am using a product called Monarch to
pull numbers out of a ASCII report and drop them into an excel sheet.  I've
been using this app for 11 years without this problem.  
In excel, I'm trying to use the SumIf function to add all numbers that ...

I have a file that I converted to an Adobe pdf file from Excel worksheets  
Now the manager wants me to take the 3 Excel worksheets and combine them into
3 pages without making 3 separate files.  How do I do that?  Can anyone help
today?

How do I take a cell in one worksheet and add it into the formula in a
different worksheet in the same workbook?

I have a problem where when I insert a formula such as ='Sheet21'!F3, the
cell shows the formula, instead of the result. This isn't consistent
apparently. I have managed to copy the formula from another cell that works,
but when I then change the cell ref (e.g F3 to F4 in the ...

My goal is to have an excelsheet summarizing the activities over time of all
departments in my company. The sheet would work as follow. On a "detail"
sheet, users would input details of projects like: start date, subject, end
date, person responsible...This information should ...

How do you set up an excel spreadsheet so where data is changed in a cell the
color of the background changes?

I have an attendance roster for the month and want to count the number of
absences. The problem I am having is that I can only count 5 consecutive
absences at one time. They can have 7 consecutive absences for one period and
then another set of absences for 5 days. That totals to 10 ...

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.
I need to determine if A1<0 and B1>0 or if A1>0 and B1<0.
If either of these two conditions occur, I need the cell of b1 to turn yellow.

How would I write a formula to produce various results in differant cells
based on a portion of a number in another cell. Excel 2003
Cell A contains a variable number.
Cell B also containes a variable number.

I would like to me able to add percentages to an IF formaule allow for a
margin of error, say 10%.  If anyone knows a way round it be much obliged.
the cell reads "=if(H2<=10%, "TRUE", if(h2=h3, "true", if(h2>10%, "false")))
Thanks

I have 30 rows of numbers the range is: d6:g35, j6:m35 (with h6:i35
blank). Each week I copy and paste one row of numbers to c59. Can you
provide a macro that will copy and paste the one row only for one week.
Then, when I run the macro again the next week it will copy the next

Here is what I am trying to do:
I have a sheet where I need to reference a date and determine what
fiscal quarter it is.  Here is what is causing me a problem: I need to
include fiscal year 2008 and our fiscal year starts in April.

I would like to have a macro which picks up my selected range in a
workbook, similair to the activecell. So when I select a range in my
workbook, it will be set as range in my macro.
I've tried active.range but this doens't work (something like this: Set