This is what I want to achieve:
If the value in A1:A10 = ABC and the value in B1:B10 = DEF, then add
the corresponding values in C1:C10 and multiply that by D1
I have tried:

I am trying to create a formula in which excel searchs an array of alpha +
numeric values for a number >0 and if true, marks the formula's cell with an
"X".  I have the logic of the formula set up like this:  =IF('B1.1 &
B1.1.1'!E31:L31>0,"X","")

Not sure how to explain.  I want to look up data in a row/cell based o
multiple criteria: Date and label.  Three consecutive columns contai
related data with a label above that data and a three column merge
cell above that containing the date.  I would like to look up data in

I am using "mode" in Excel to return the most common numeric value in a
questionnaire field.  One domain contains two equally-represented values ("1"
and "2")."Mode" returns a value of "1" if the list is sorted in ascending
order, and returns "2" if the list is unsorted.  I can ...

I am attempting to create a function to do the following.
I have to columns of data that I need to go through. I am attempting to
talley the number of occurences of each item.
To do this I need to go through column 'a' and every time it is 1, i then

I'm looking for a formula that will convert a time in minutes and seconds to
total seconds. EX 3:46 which is 3 minutes and 46 seconds and is 226 seconds
total.

I want to sum up all the value such as "aa" instead of softing and usin
function sum/if. But it doesn't work. Any expect can help? Thanks.
1  aa  10
2  bb  40

In the formula :
INDIRECT('Work-Space'!$G$3,B12)
what is the function of the exclamation point?

How should I set if there is dialog showed that:
The text string you entered is too long. Reduce the number of characters
used or cancel the entry.
and I can't click anything for adjustment?

       A        B
1      Ford     June
2      Ford     May
3      BMW    June

I have to type a list of approximately 1,000 student names, among other
functions, and my supervisor wants the names in alphabetical order.  Can
Excel alphabetize the names for me or do I have to do it manually?

ok for instance i have to find the average net sales for each age group, ie
age groups 20-29, 30-39, 40-49 etc all the way til 70-79.
i have a list of net sales ie column  I2- I101
and a list of ages(H2-H101) from 20-79, but in no order! (random)

HELP Please! I have created checkboxes (Y/N) in from the forms tool bar. I am
trying to be able to only select 1 box at a time.  When I tried using the
option buttion it worked but, I need buttons in other places on the
worksheet. When I copy and paste the option button I still ...

How can I "disable" a Drop down list (but still have it in use if the
overall Sheet protection is off)?
I thought it would work via the Sheet Protection, but my sheet is protected
(as are the cells locked where the Drop down is) but I still get the option

I would like to display details in pivot table without opening a new
worksheet.  I can do this in access but excel forces me to open new
worksheets.  Any ideas?