I am using this formula to count the number of ages to add to a group of ages.
It is fine until I have age of 21 or 30 to where it is missing the age range
in the count.  Please can you help so i can pick these missing ages in my
report.

I am trying to calculate the time expressed in hours and minutes based
on the average speed and distance travelled, but I'm having trouble
getting it to display correctly as e.g. 00:16 for 16 minutes.
For example I might have 16.8 as the miles travelled in cell A2 and 64

Here is how the data is setup:
A                     B           C
Type               Qt.          Rate
Category1         5           $10.00        

I have a column that has scheduled times in it (i.e. 8-6) I would like the
column next to it to list the total number of hours that this equals (in this
case 10). I could create a seperate column for each time in/out, but I am
trying to keep the sheet as simple to the user as ...

I need column names for quarters 4 quarters forward and 3 quarters backwards
along with the present  from the an entered date as shown below:
   3Qtr06 4Qtr06 1Qtr07 2Qtr07 3Qtr07 4Qtr07 1Qtr08 2Qtr08 3Qtr08
I believe the issue I am running into is leap years . Depending on the ...

Hi;
I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Can anyone show my how to combine multiple files (189) with the same
number of columns into one master excel spreadsheet.
Thanks.

I have a column which I am trying to get the number of occurrances of "9" for
example. The "9" is a formula of two functions 1) VLOOKUP in another column
and 2) SUM of various VLOOKUP columns.  I can't get COUNTIF to work on either
of these columns.  I think it doesn't like SUM ...

I don't imagine its much different from 2003.
I am able to open the slide show in Power Point from using a script in 2007.
But even if I set the TestPP.ppt file to open automatically in the viewer,
when I use the script, it launches Power Point.

I need a cell to change into four (4) different colors if a specific
condition is met.  For example if A1 matches a text value “A thru E” I need
“red”, if it’s a “F thru J” then “blue”, “K thru O” then “green”, “P thru T”
then yellow.

I am having issues refrencing cells within a the function.
If J1 holds the text "April", I am using:
=GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project
Text RMT]","[Project Text RMT].[All Project Text

Using Microsoft Excel 2000, I'm attempting to make the max value and min
value of a set of unique numbers turn a certain color. I've tried numerous
different ways using cell value and formula but am unable to have just those
two values turn to a different color. Usually I'll have ...

Good Morning,
Other than using the validation method and producing a dropdown box, is
there any other methods available to show a list and allow a user to select
one (or more) selections in a cell, while still displaying all of the choices

I have to import information stored in an access table into excel every month
in order to update the excel spreadsheet. I would like to automate it with a
macro but I need a code for it? How do I do it?
Thanks!