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?
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...
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...
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...
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 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.