How do I do a set up the fcn to count all cells in a range that are >0% and
<25%?

I have a workbook w/ several sheets. A few cells in each sheet accumulative
sums of data from all the previous sheets. I've been doing this w/ a cell
formula like "=C14+SheetN!F14" where SheetN is the name of the previous
sheet.  If I reorder the sheets or add a sheet in between ...

I made a template with my formulas and I have some lines that I need to put
zero's in so I won't get #VALUE! where my formula is.  For example:  J16*K17  
is the formula for L17.  I have to put zeros in my J & K columns if I'm not
using them or my L17 shows #VALUE!   The first 5 ...

http://www.contextures.com/xlDataVal10.html
I have a cell that has a scroll-down list of names (made thru data
validation) - data validation can't give me matching items in the list (has
to scroll and click) so I found the solution in creating a combo box.  I

I have read the other posts similar to my question - but I still do not
understand.  Please help.
My problem is I would like to lookup a code that is specific to a value to
determine if it exists in a table of data I have created.  For example the

I am working on doing inventory and my boss would like a spreadsheet where we
can enter our inventory for this year and automatically copy the items we
need to another spreadsheet to print and order from.  Basically, we have
columns with the inventory information (item, brand, ...

I have a row of yes and no answers.  How do I count only the yes answers in a
pivot table?

Is there any mechanism in Microsoft Office which will send an email
when an Excel (or Word) document has been amended?

Sheet 1  
  A              B                   D                F              G      
             N                    
Cust #   Customer          Product         Roll           Cut                

Hello again,
I forget the formula to find tha last value in a row
A    B    C    D    E    F=RESULT
AA    N1        N2        N2

Good afternoon!
Can anyone tell me if there is a way to save a custom sort for future use.  
We have a complex sort that I would love to have available without having to
create it each time.

I have a range of cells with dates like: 1/1; 1/15; 1/31; 2/1; 2/15; 2/28...
To the left of the range a user will enter a date. I want to make sure that
the date matches a value in the range above. For example, 1/7 is invalid
whereas 2/1 is fine. I'd prefer not to use a dropdown. ...

Suppose, i have 3 incentive slabs
No.of sale            incentive slab
1-10                     no.of sale*8
11-20                   no.of sale*10

Here is my dilemma…..I am using Excel 2007.  I have a spreadsheet with
17,3322 row of data that spans to Column W (A2:W173322) excluding the
header.  I am trying to do conditional formatting to bring to light
the duplicate values that are identical across the row and highlight

"When I right Click in a cell, then click on "Format Cells" nothing happens.  
The other "..." options show options to choose from, but "Format Cells" does
nothing!
Can someone help me, PLEASE!