I need to weight my percent of change by province.  E.g.
    2004    2005    2005 Distribution    % Change    Weight
AB    182    268    6%                         47%       2.8%
MB    1,285    1,295    29%                          1%       0.2%

I have a simple spreadsheet with a value in column J (our price).  Columns K
through R are the prices our competitors charge for the item.  I need to
compare column J to the others and shade J if the price is less than or equal
to any of the values in K through R.  

The following is my formula, how do I get it return 0 instead of #N/A?  I
tried
VLOOKUP(A17,'November 2007'!C$3:R$261,14,FALSE)+VLOOKUP(A18,'November
2007'!C$3:R$261,14,FALSE)+VLOOKUP(A20,'November

I have 4 named Columns, for simplicity they are: Code, Red, Blue and Green.  
In the Code Column are the numbers 1,2, or 3 and are random.  The Red, Blue
and Green Columns contain numbers anywhere between 1 and 100.  But, not all
the rows in the coloured columns contain numbers.  ...

I have a worksheet that gets data from external source. I need to sum
numbers in Column C if  date in Column B is >= another cell.
I tried:
=IF(B:B>=F2,SUM(C:C))

I need to sum cells on sheet1 from sheet2 that have no fill or white
background.
In a cell on Sheet1 I used:
=SUMPRODUCT(--(ColorIndex('Sheet2'!C:C)=2),'Sheet2'!C:C)

In Workbook 1 I have a mailing list with typical fields, name, address, city,
st, zip, etc. This workbook has over 50,000 records and I need to pare down
the list based on zip codes.
In Workbook 2 I have 600 zip codes in column A and a unique value for each

If I use the suggested formula
"=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)"  
It will indeed calculate the number of months inbetween two dates, however.
If the date is in question is 2/9/05 and todays current date is 2/8/08

Ive created simple a pivot table in Excel 2003 that sums by values.
Does anybody know how to suppress these zero values so I only see postive or
negative values in my table?
Thanks

Could someone explain what the last 2 and the 0 characters in the function
actually mean ( or achieve ) in the following statement
=HLOOKUP(c3,d4:h4,2,0)
eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages.

I am trying to use the YEAR function in excel. I need to figure out (years of
service) between the original Hire date and the current date. EX
11/01/1961 -  original hire date
2/08/2008 - current date

In a row I have 4 to 5 unique fields, that can appear in more than 1 column.  
I have a function to count all the text fields but I would like them
separated into unique counts.
Exp:  blue red  green  red  red  blue  green green = how many red, how many

Looking for your kind help on the below:
In a spreadsheet I have the following cols and rows:
Col B    Col E   Col F   Col G   Col L         Col Q
Date     Artnr   Pcs     Price    Order#     Formula

I have a column containing trap names which are labeled as a letter followed
by and number and an "i" or "o" depending on whether its and inside trap or
outside trap. So I want to make a column using an If statement that if the
trap name column contains an "i" its value is inside ...

The following formula works great if you want the cell name to be the current
sheet.
=MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024)
Is there a way to reference a different sheet?  For example is there a way