multiply column

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