multiply column

  1. G

    Multiplies and SUMMARIZE columns

    Hi, I'd like to multiply the values in column C by those in column E and display the sum in cell F2 without creating an additional column for the intermediate results. Is there a solution for this problem?
  2. X

    Conditional Multiplying

    Hello people! I am quite new to proper work in excel and I need some help! I have this table with sales and revenues from the months december 2014 and january 2015, the sales and revenues are made in 5 currencys, FX rates are given in another sheet . I need to calculate everything in euros...
  3. N

    Multiplying entire columns

    Is there a way to multiply every cell from Column D19 through D50 by their corresponding numbers in column G19 through G50 and adding the totals? i.e. =(D19*G19)+(D20*G20)+(D21*G21)+(D22*G22)+(D23*G23)+(D24*G24)+(D25*G25)+(D26*G26)...etc.? I'm doing it long-hand but thought there may be a way...
  4. A

    Taking a value from another sheet and multiplying (cost x hours) and combining days, weeks months

    Hello everyone, I have tried to make a sheet which has Resource, Task, Rate (I'd like this to be on another sheet, as it does not help here and is a lot of repetition) Also, right now the columns for hours are based on weeks, but i'd like to do it by days and then collapse by weeks, and...
  5. R

    Auto-calculate 2 column that contains numbers and words words

    Hi everyone, I've been using conventional method to do this and it's time consuming. I would like to total up 2 column. A multiply B to be exact. Below are some examples: Table 1 - Before totaling up: <table dir="ltr" border="1" bordercolor="#05ad00" cellpadding="2" cellspacing="1"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top