I have two sets of numbers in Rows A and B.
I want to create a total at the end of each row along the lines of
=(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122)
Is there a short-hand way to do it, eg via range names. If so, any

I am trying to set up a spreadsheet in Excel 2000 that allows me to input a
date that an item is requested (J4) and then keeps a record of the time
passed (L4) up to the present date until I input the date the request was
received(K4), eg

I would like to have a formula that will subtract the sales tax from a
sale. Ex. If I sale a product for $10, I have to charge 7.75% sales
tax. the customer will have to pay me $10.78 in total. I would like to
be able to tell my customers

Excel Cant read dates separated with point (not even using formatting in
Armenian)
example: DD.MM.YYYY
how could I convert that format into DD-MM-YYYY, I have tried almost every

I have a question. here is what i have so far. I want to know if the change
for a specific account meets or doesnt meet the criteria. for example for the
first data i want it to lookup the account number 7400852 in the table and
then see if the change falls in between those ...

can anyone give me all the functions in the excel worksheet with eg. Or if it
is difficult......... give the link of the web page that contains the details
of the functions......

How can I turn off or disable AutoFormat in Excel 2007?
I mean that I write the value in a cell then Excel take it and convert it to
date format. It is annoying to me and working these kind of records.
Thanks in advanced!

I having some datas in one column 9n many rows. i want to take reference in
some letters fot SUMPRODUCT FUNCTION
EXAMPLE
COL-A                             COL-B

Please help with the below formula
=IF(AND(H3>0,I3>0,J3>0),"Loyal$$$"),IF(AND(H3>0,I3>0,J3=0),"Retained$$0"),IF(AND(H3>0,I=0,J3>0),"Returning$0$"),IF(AND(H3>0,I3=0,J3=0),"New$00"),IF(AND(H3=0,I3>0,J3>0),"Lapsed0$$"),IF(AND(H3=0,I3>0,J3=0),"Lapsed0$0"),IF(AND(H3=0,I3=0,J3>0) ...

What is the difference between these two formulas?
       sumproduct((RangeA=CriteriaA)*(rangeB=CriteriaB)*(SumRange))
       sumproduct(--(RangeA=CriteriaA),--(rangeB=CriteriaB),--(SumRange))
What exactly "--" represent?

What I have is a sheet with duplicate URL’s in a column and I want to
know what rows the duplicates appear in.
For example:
Row          URL

I'm trying to calculate de cumulated probability Fisher law for the degress
of freedom df1 and df2. Is this possible with MS Excel?
Actually I always have to go trough the ANOVA on way tool and this is
boring. Any idea?

I am trying to create a formula that will create the following:  Column E
Compensation, Column G Emp contribution, and C Date of birth mm/dd/yyyy.
The match 100% of 1st 3% and 50% of next 2% No match over 4%.  Also no match
if employee is under 21  of age at 12/31/08.

hi all, i'm not much of a guru with Excel. how do i prevent the #DIV/0! when
a column i'm dividing by is a 0.
i'm using Excel to calculate the Delta %. i'm using a simple formula
(K-L)/K. a lot of rows have values but obviously if for example K9 is 0 i'm

How do I get the Col letter and Row number of a cell (without the page name)
to appear as text in another cell?
Using the =CELL("address",xxx) and clicking on another page for the xxx cell
places the entire [workbook name]sheetname!$col$row in the cell.  I only want