Hello and thank you for looking at my problem.  I have a column of
numbers say 1 to 100 (A:1 to A:100) and I want to count the number of
cells in that range that are between 30 and 50 and including 30 and 50
(count should be 21). I've tried most count functions but can't seem to

I have a series of values in which the maximum value occurs several times.  I
am trying to create a formula for each offsetting cell in column B that flags
the first occurance of the maximum value only.
For example, the sample data appears in column A.  The desired output

Would like to know the function that returns the number of months, for
example to return 20 for the months from Feb-2008 to Sep-2009.

from     E = [(a+b)^2]^1/2
write in excel is  " =sqrt((a1+b1)^2) "
but I need to find a volume of  "b"  but,I have a "E" and "a"
How to writr a function for excel to calculate to give a volume of "b"

How could I adjust the formula below, so that I can drag to columns
A:Q without having to change the last digit for each column?
=VLOOKUP($A12,Report!$A$12:$Q$37,2)

Hi I need help
Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:

I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but
the criteria should be 'the cell (within the range B1 to B100) contains the
string in cell C1'. How is it possible?
Thanks, Michael

I would like to write a formula that sums the values in cells A1:A5 while
excluding the value in cell A3 only.
For example:
A1 = 2

here's my situation: I need to round all decimals that result from an IMDIV
function to two decimal places. I have Excel 2007, I have already tried
numerous ROUND functions, formatted the cells to round to two decimal places.
But on repeating decimals it will not round, only on ...

I am trying to return a value for a code of mixed characters from a lis
of a possible 250 codes. I want to identify potentialy 30 of those code
and return a value dependant upon that code. For example
Code              Value

I have a row, L3 to L200 that has this selection, Scheduled o
Unscheduled. I want the total "Scheduled" to display in cell F1 an
"Unscheduled" in G1 like this if possible. This will auto update th
count as the selection is chosen from the drop down menu in column L3.

IN my pricing list
one is numeric in which i am entering prices and other one is date , which
gives me the information of on which date i received the prices for
particular product.

Download DeDupe 1.6.4
hi am trying to download , but one htm page is download name like .exe
what can i do how can i download the dedupe this version help me

Try typing the following ...
=MOD((1/(TAN(PI()/4-ATAN(120/119)))),1)
This produces the answer 1 in Excel 2000 and Excel 2003.
I think it should be zero, because the expression before the comma in MOD

I would like to add a row above certain cells that repeat themself. For
example, Column T list several company names like this.
Arby's
Arby's