Question about Microsoft Excel for PC

1 Answer

Excel formula is there a simpler way to write =(D4*B4)+(D5*B5)+(D6*B6)+(D7*B7)+(D8*B8)+(D9*B9)+(D10*B10)+(D11*B11)+(D12*B12)+(D13*B13)+(D14*B14)+(D15*B15)+(D16*B16)+(D17*B17)+(D18*B18)+(D19*B19)+(D20*B20)

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers
Re: Excel formula

Yes, there is a function in MS Excel called "sumproduct" which multiplies the componenets in an array or arrays, then totals the result, eg :

=SUMPRODUCT(D4:D20,B4:B20) ...Job done...Enjoy !

Posted on Jan 19, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What is formula to find percentage of females in my workplace?

      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

    How to Calculate Percentages in Excel > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Business & Productivity Software

2 Answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer


Step1. Start Microsoft Excelmag-glass_10x10.gif and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. $('.Article .Steps .Image').each(function(i,e){ e = $(e); e.find('img').error(function(){ $(this).unbind(); e.remove(); }); });
Tips & Warnings
  • Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
  • Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

4 Answers

I need Excel's Furmula's

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

This link has some custom formulas for excel that you can download:

Sep 20, 2008 | Microsoft Business & Productivity Software

2 Answers

Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

3 Answers

How many formulas we can use at a time in Excel

That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula

Make sure that the cell is formatted as a number, not as text. (Right-click the cell, format cell, number, choose NUMBER.)

Dec 19, 2007 | Microsoft Excel for PC

1 Answer

Excel Formulas
check this link for all excel formula

Sep 23, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

200 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides