I need to calculate the number of times an item appears within a date range.
Another words, if column A is contains my dates ranging from 1/1/05 - 7/1/05
and column B contains various symbols (ie A, B, C etc.), I need to calculate
how many A's appear between 3/1/05 - 3/31/05.  Is ...

When I try to look with vlookup for a value that is not in the table
indicated, I get the message #N/A which indicates that the value cannot be
found (this is normal).
I would like to change this message #N/A into a value 0 or a blanc ""

I would like to Sum the Count of numerical values in Every 3rd Row BUT ONLY
IF the value(s) equals a specific criteria.
Example:
Sum Count of Every 3rd Row that has a value of 50. The criteria will vary.  

I am wondering if there will be room for a ruler in the excel program. I drew
a roof in 5 min with the boarder feature but there's no where that I could
find that you can caluate the measurments

How do I enter Today()-30 as a criteria in a sumif function?

I need to know how to delete the (ABCDEF........) headings when we print but
keep the (123456.....) Row heading in the print screen. Can you help and can
it be done?

does anyone know how to add a drag -down list box and if I choos a from my
list, it will give 1 to cell B1, If I choose b from my list, it will give 2
to the same cell B1, and so on. Thanks.

I am trying to setup an end-of-day financial report that will contain
transactions by payment method (i.e., credit card, debit card, check).  I am
creating this for my co-workers to enter what payments were made and Excel
will do all calculations.  We are having problems with ...

I have a row of mixed data that gets used elsewhere with a vlookup
table. some cells are blank. I would like to place a sum of all the
vlookups into a single cell. I have tried using the sumproduct
(isnumber(match(index...... method but it doesn't seem to create two

I have a macro that I have been using for 6 or 7 months and it was working
fine.  Today it had a run time error for no reason that I can see.  I also
use this another macro just like it except a different sort number.  It is in
windows 2000 with excel 2000.  Here is my macro:

hi,
how can i calculate the end date(mm/yyyy) betwen one cell where i have a
date(dd/mm/yyyy) and in another cell i have a number of month(12)
ex: A1: 01/01/2005    B1: 12  in C1 i should obtain 12/2005

I have a string in a cell which is a full address string.  I need to check to
see if the address is a Pennsylvania address, and then if it is, I need to
find what the city listed is right before the PA.  The way I am tryign to do
it is as follows:

I receive daily updates from various suppliers.  Instead of dragging and
dropping their new data into my one master price list, I would like to have
Excel look up and replace the old prices with the new prices into my list for
each supplier.  Is there an easier way of doing this ...

I have a spreadsheet that I would like to count the number of occurrences of
a particular value in one column that also have a particular value in another.
For instance, I want the number of times the value in column B = Yes when
the value in column C = 0.

I use excel 2003
Is there a way to create a search box on the top of a sheet instead of
continually using the find option under "edit".
I would like to be able to find a particular employee amongst 5600 rows then