I'm trying to disable total and subtotla for a single column in Excel 2007.
for example:
Data:
Name    Target    Sales    Percent

I am trying make a formula that returns a value if all of them are the
same in a column but it has to include blanks.  Say column H1:H10 is
the range and one and H1=2, H4=""or blank, H5=2 and so on....I need 2
to populate the cell.  Now lets say H1=2, H4=""or blank, H5=4, I need

I am new to this and am quite cornfused. I am trying to set-up a hyperlink
from one tab within an excel doc to another tab within the same doc. But when
I set the hyperlink to go to a particular cell..and that other tab is
altered, then the link is no longer valid. Within each ...

I have a list of number with many duplicates. I need to know how many unique
numbers are in that list. For example if the list was 2,2,2,3,4,5,5,5,6 I
would like to know that there are 5 unique numbers in the list.
This spreadsheet will be updated by people who are not familiar ...

I have used this function on a golf league score sheet:
=IF(SUMPRODUCT(COUNTIF(INDIRECT({"C7","C11","C15","C19"}),C22))=1,"Winner","No
Winner") to figure out which score for that hole is the lowest and that it is
not duplicated.

I have a vlookup formula setup as follows:
=VLOOKUP(A7,'[sp 500 constituents.xls]Classification'!A$2:J$501,5,0)
The value listed in column 5 on "the sp 500 constituents" spreadsheet has a
8 digit number.  This value is only showing the first 4 digits in the second

We have an excel document which we keep track of dates and if a notice was
submitted on time. We want to create an addt. worksheet that will search the
main worksheet for ALL "NO" responses (set up as an IF function) and return
to us the following info:

I HAVE A SPREADSHEET THATS LIST SALESPEOPLE BY NAMES.
I AM TRYING TO ADD A COLUMN AT THE BOTTOM THAT WILL ADD EACH TIME
THE INDIVIDUAL SALESPERSON'S NAME APPEARS AND GIVE A TOTAL FOR THE PAGE.

Hello -
I have a project that will cost $10MM to build over 12 months.  I would like
to spread the costs out in a bell curve shape.  For example, I would like
something similar to the following costs...

Has anyone had the problem of setting a password on a worksheet in Excel
2000 (MS Office 2000 Pro. Suite).  It will let me go through the routine of
creating the password and it indicates that a password has been set, but
when I reopen the spreadsheet it doesn't ask me for the ...

Much of the cell formatting has just disappeared from my Excel 2003
worksheets since I recently installed Excel SP2.  The colors are still
highlighted if I click on the fill or text button, so the formatting is still
there - just no displayed.  If I now try to fill a cell nothing ...

Hi, I'm setting up an overtime metrics worksheet.  I have two sheets.
On one sheet I have all employee names in column A and pay dates in
row 1.  On Sheet 2, I have the same dates in Row 1, but the names in
column A are simply sorted in a different manner (by work group).

Is there a way to lookup information in a table using both colm A and B as
the lookup value?
For example I have a list of names in Colm A and in Colm B I have one of the
four (1) Premium (2) Comm (3) Paid (4) Profit.  The four things in colm B are

I need to sum the subtotals in a field, and it appears the best way to do it
is to add all of the cells that are above a blank cell. For example:
            A
1    <FORMULA>

Hope the table below is still correctly formatted.  You should see the top
row with 4 distinct "exact" year values (25, 30, 35, 40) and the left most
column with "approximate" percentage values.  I need a formula that will
lookup this table to return the following result: