Hi there excel gurus.  I'm stumped as to how to rectify a bug in Excel2000
with the COUNTIF function.  Simply put, the number is not coming up
correctly.  I have a very simple function:
=COUNTIF(Current!D1:D10000,">=180")

How can I format a cell to display the current quarter?

I have the data below and want to do the following: In ONE cell, I want
there to be a count of the IDs that have an X in more than one rule.  In the
case below, ID 1 would be counted, but ID 2 would not, ID 3 would, etc.  Any
help?  Thanks!

I have a workbook that has several sheets for calculating information.  I am
trying to set the formulas to count even if there are more rows added at a
later date.  How do I set the formula to count the whole column?

I have a table on Sheet1 with strings in column A. Say for simplicity's sake
that they are colours.
A
red

I have my lookup table, which is has a defined name of  Code1 (see below).
Can a Vlookup formula that would look in cell CU4, which has the Code 10,
and return the sum of all the Code 10's in the lookup table. In this example
the result would be 12.

I have few lines of text in a cell and I am not able to separate it with the
individual cell for each lines.
For ex: for one invoice number in cell B1, the text is some kind of merged,
if I click on that cell I can see entire data and I am not able to separate

Vista SP1.  Excel 2007 (Excel 2003 compatibility mode).  I juts (painfully)
discovered that if you use High Contrast the fill colors will not show in
one's Excel workbooks.  It would be nice to have a warning!  Any way to
resolve the issue?

I am pulling data in from an external data source (sharepoint list) the data
is updated and new rows are added daily.
One of the columns is a milestone value.
Is it possible to take the raw data from the import and automatically have

I want to be able to insert a phrase such as Month 3 where the month number
is entered in a different cell (say B4). I have therefore entered formula -
concatenate("month ",B4) and it returns a #value! error. Both cells have
general format. When I do this on a brand new ...

How to supress #N/A in an array formula.
Using Excel 2003.
The formula below calculates where a call has been replied to within
it's alllocated target time.

I have a column with lots of dates in.
I want a formula to count the number of dates, ie jan 2006 = 12
Any ideas,
Ive tried CountIf, and 2006 but i think the date formatting is messing

Does anyone have any free templates for small business or offic vacation
planners?  Or, maybe someone could tell me how to make it so that whenever
one of my employees types in a phrase, the excel document converts it
automatically (in ANY of the linked spread sheets) into a ...

I need to do  this:
A                         B                            D                    
   F                    H
32                       3                              2                    

I have a spreadsheet with dates in Column A, and either the word "Res" or
"Comm" in Column M.  How can I find out the percentage of "Res" for all the
records in January?  
PS - there is an abundance of extreme talent in this community!  Thanks for