I would like to know if it is possible to get a sum total from two pages on a
worksheet when each page is set up with the same Title and Column headings
but with the title merged across the page. My employer does not want me to
freeze the panes for the title and column headings.

Maybe I am expecting too much.
I have a field which has custom format 1234 000 000  OR   0000 000 000
After this field has been populated I want to copy and paste the data to
another column.   Of course it only reads the figures I input, is there a way

I need the number 1,802,224 to be  pulled from anothe rworksheet and be shown
as 1,802. as the result.

I was wondering if someone can help me with computation funcationality issue.
What I am trying to do is obtain a $ difference between 2 numbers  with
these parameters based upon 3 different levels, 2 different cities, and 3
types of categories.

Is there anyway to write an if statement for a range without identifing each
cell?
Ex: If cells A1:AA1 = "test","proceed to next sheet","stop".  
Thanks,

This is similar to other questions I've seen posted but unfortunately I can't
get my formula to work.  If the value I lookup does not have a value on the
pivot table I'm searching, I'd like to return a blank cell instead of #N/A in
the cell.  The vlookup formula I'm using is: ...

How Would I code A1= A2 (When selected).A3 (When selected) in Excel

Is there a way to create an if statment that involves two different cells;
ie "IF B2=>3, AND C2=>1, YES, NOT YET"
I've tried:  =IF(B2>=3,(AND(C2>=1,"YES","Not yet")))
but it returns a #Value!  error.

Hello -
I'm not certain how to explain what I'm looking for. I don't know much about
arrays, but I think that might be what I need.
I have a sheet that has:

I'm using Excel 2003 and trying to set up a situation where an "If" statement
would allow me to place a "validation drop down list" in the cell if the
conditions of the if statement return a logical "true".
That is, if I'm in cell B2, and my conditional is "=if(A2>0,XYZ,0), and ...

I found on one of the other posts how to do a row conditional format
using this formula in the "Formula is" option:
=(A1="variable1")+(A1="variable2")
Now the problem I'm having is when I want to copy them down for the

Thanks to the help from a prior posting, I have the following calculation in
my spreadsheet:
=HLOOKUP(A5,INDIRECT("'"&$A5&"'!D2:H104"),3,FALSE)
This macro searches through several worksheets with lease numbers (e.g.

I need to have users input a starting week number in cell A1 and an ending
week number in cell B1. In cell C1, I need to compute the average volume from
the first week, based on the variable the user input, through the last week,
also based on user input.

I am in the process of converting ID codes that are text. In column B i have
a variety of labels, ie.. shirt, sweater, hat. They repeat over and over
again. I want column C to contain the word "summer" everytime "shirt" appears
in Column B,   "fall" everytime "sweater" apears and ...

How can I get the results of an @if function to be displayed in a different
color that would make them stand out?