Am I allowed more than one question?  :)
Maybe someone here knows.
Looking for 3 items from a spreadsheet.
In Column A: Have dates in no particular order for shipments spanning 5

Hi everyone.  I have two columns of various information and I want to count
the number of rows that have both "accept" in column 1 and "february" in
column 2.  I want to avoid having to create another column of data.  Thanks
for any help.

How do I create a function that looks at a column of numbers and give show
the smallest number that is greater than zero?   I tried a nested if function
but it doesn't give me the correct answer.

I am trying to streamline a mathematical optimization program that I wrote in
Excel with a macro.  Say that I have typed a formula into cell A1 as a text
string, such as "x^2+10*x^4".  Next I have renamed cell B5 as "x".  I want
the cell C5 to convert the formula written as a ...

I have created a drop down list in Excel 2003 Ver 11.5.
Now I want to edit, or add to the list. HOwever I get a error message that
states the user has restricted values that can be entered into this cell.
I have gone to Data - Validation, and tried to see my list there, or add to ...

I got som values in Range("A10:A100")
There are some empty cells inbetwin
The 'list' grows  but only inbetwin row 10 and row 100
There are values before and after 'my' range that i dont wana use

I am trying to sort a column with numbers and text eg;
.75-2-mbv-167
.75-2-mbv-168
2-2-mdv-004

I am using VLOOKUP with a range of part refs some are numeric only, some are
alphanumeric.
My lookup is working fine with the alphanumerics, but not the numerics.  
Please help.  I have tried formatting all refs in each worksheet as text to

=SUMPRODUCT((INPUT!$B$2:$B$20000 = A2)*(INPUT!$A$2:$A$20000 =
MONTH(NOW()) -1))
I would like to count the number of records from the previous month
regardless of what month it is.

Oh great ones,
Where to begin.  I want to combine IF to test what RIGHT returns and based
on the answer, point it to VLOOKUP to return a cell content (which is a long,
complicated path).

I have a commission statement that I need to set functions in.
I need to say if cell C30 is less than or equal to 20, then C31=$40, if C30
is between 21-40, then C31 is $60, if C30 is between 41-50, then C31 is $80,
and if C30 is greater than or equal to 51 then C31 is $100.

I think that using an array formula will solve my little problem, but I only
understand a little about them, and the formulae are only returning blanks.
I have a table of data, that I wish to rearrange into a grid based on
entries into 2 columns with restricted values allowed.

I'm doing a simple spreadsheet with a few child sheets that point back to a
parent sheet with an overview of information.  I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3).  The problem that I've got is ...

any one out there to help me
MY FORMULA
=` IF
(countif(8:18),:=;="p")=7,"Distinction",IF(countif(C8:G18,"p",,)=5,"Merit",IF(Countif(C8;E8."p")=3,"NOT YET ACHIEVED" )))

Please tell me how to make array sum of the product at a formula with
thanks.