Which is more advantegious sumif or sumproduct in terms of execution speed?
the following are my formulae both are giving same result.
=SUMif(SCHOOL!$J$1:$J$950,$B$1,SCHOOL!$V$1:$V$950)
=SUMPRODUCT(--(SCHOOL!$J$1:$J$950=$B$1),(SCHOOL!$V$1:$V$950))

I have cells on the worksheet that when you select an option from a drop down
list you type in a response.  I need to clear these cells as a different
option is selected from the drop down list
i.e  A1 - drop down list with options

If I have a number in a cell (e.g., 3.456), how can I return just the decimal
part of it (0.456) to another cell?  Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

I have two columns starting at I2 and J2. I need a formula that will tell me
what dates in I2 come before or expire before those in J2. Right now I have
the columns formatted as Number, Date, 03/14/2001. I have tried =(I2<J2) but
that is not working and I guess it's because I am ...

Does anyone know if it is possible to use a formular that would return a
selected range (from a different worksheet), based on the content of a given
cell?
I want to use the first worksheet as a form with the second worksheet

I am trying to get a header in excel to reference to a cell in a different
sheet.  Is that possible?  Thanks!

I have downloaded an excel document from PDF format to Excel and doing so has
given me hundreds of blenk rows in the data source.  Is there a way to select
the worksheet and tell the program to delete all blenk rows? To condense my
worksheet and make it a more workable document?

I have a cell that contains several thousand characters of fixed-length data.
I've been able to parse out various values using a file layout that I refer
to for location and length within this cell (the thousands of characters are
for several hundred fields, so I don't want to ...

I have 5 departments each with at least 35 employees. Some of th
employees are listed in more than one dept based on % of their time.
have an annual salary spreadsheet with all their names. A task is give
to me where I have to identify a) employees listed in multiple dept b

can any help with VBA code for the below case  IN EXCEL
A      B    C
X      3     8
Y       5   10

I want to have a table where in one row there is one variable while on the
left column there is another variable. Inside the table there are the values
which depend on the two variables, including a fix value which is outside
that table. i am looking at excel spreasheet like that ...

I am working on a spreadsheet that when I enter or select certain
information, other column and line info needs to change (always the same
info) too. For example:   I enter a name "joan" in A2.   B2 needs to have a
certain rate for Joan, and G2 has a certain other piece of info ...

I have two worksheets.  One with 1000 rows of part numbers (SHEET1) and the
other with 16000 rows of part numbers (SHEET 2).
I would like to compare the sheets.  
If "SHEET 2" has a matching part number in "SHEET 1"; then copy the data in

how to put three columns into one dialog box?

I need a formula that will rank a given value against a set of other values.
For example, in column B, the numbers are 100, 90, 80, 70, 60 etc - i.e.
sorted in descending order.
I enter the number 63 in cell D1.  In cell E1 I want a ranking formulat that