Conditional Multiplying

[Xcelcool]

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 before i put everything into a pivot table (or at least i think so), so yeah, what should I do?
I'll post a picture to show you how it looks like (country not relevant).

 

[dave3009]

Hi and welcome to the board.

I'd be inclined to suggest rearranging your data to make things easier.

Please see example:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Date	Area	Value1	Value2	Currency	Rate_Date	Rate	Conv_Value1	Conv_Value2
2	30/01/2015	Area - Not Important	6999.00	4899.30	EUR	2015-01	1	6999.00	4899.30				Curr_Code	Date(YYYY-MM)	Rate
3	05/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				CAD	2014-12	1.3933
4	11/01/2015	Area - Not Important	6999.00	4899.30	CAD	2015-01	1.2545	8780.25	6146.17				CHF	2014-12	1.2296
5	26/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				EUR	2014-12	1
6	28/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				GBP	2014-12	0.8525
7	05/12/2014	Area - Not Important	6999.00	4899.30	USD	2014-12	1.3223	9254.78	6478.34				USD	2014-12	1.3223
8	07/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				CAD	2015-01	1.2545
9	03/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				CHF	2015-01	1.2022
10	09/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				EUR	2015-01	1
11	14/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45				GBP	2015-01	0.8123
12	10/01/2015	Area - Not Important	6999.00	4899.30	EUR	2015-01	1	6999.00	4899.30				USD	2015-01	1.2666
13	14/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45
14	05/01/2015	Area - Not Important	6999.00	4899.30	CAD	2015-01	1.2545	8780.25	6146.17
15	19/01/2015	Area - Not Important	6999.00	4899.30	USD	2015-01	1.2666	8864.93	6205.45
16	11/01/2015	Area - Not Important	3750.00	2625.00	USD	2015-01	1.2666	4749.75	3324.83
17	19/01/2015	Area - Not Important	7500.00	5150.00	CHF	2015-01	1.2022	9016.50	6191.33
18	17/01/2015	Area - Not Important	7500.00	5150.00	CHF	2015-01	1.2022	9016.50	6191.33
19	08/12/2014	Area - Not Important	7500.00	5150.00	CHF	2014-12	1.2296	9222.00	6332.44
20	12/12/2014	Area - Not Important	7500.00	5150.00	CHF	2014-12	1.2296	9222.00	6332.44
21	08/12/2014	Area - Not Important	8900.00	6230.00	CHF	2014-12	1.2296	10943.44	7660.41
22
Sheet4

Cell Formulas
Range	Formula
F2:F21	F2	=TEXT(A2,"yyyy-mm")
G2:G21	G2	=SUMIFS($O$3:$O$12,$N$3:$N$12,F2,$M$3:$M$12,E2)
H2:I21	H2	=ROUND(C2*$G2,2)