G
Guest
Hi,
I have two tables with two columns each which I am displaying below in csv
format:
Table # 1:
Store, Sales
A, 5000
B, 4000
C, 6000
D, 2000
Table # 2:
Store, Region
1,North
2,South
3,North
I need to fill a table with the following format:
Region, Total Sales
North, <Total sales for North>
South, <Total sales for South>
I need hep with the <Total sales formulas>. I know a workaround is to create
an additional column next to Table 1 to display the Region and then use
SUMIF. However, this is not something that I can do in this situation. I
tried the following formula, with A8="North":
=SUM(IF(VLOOKUP(Table1_Col1,Table2,2,0)=A8,Table1_Col2,0))
However, this formula gives me 17,000 as result (instead of 11,000). If I
replicate the formula row by row (in non-array format), it does work...
Any help is greatly appreciated! But please remember that I need only one
formula in one cell.
Thanks!
Lucas
I have two tables with two columns each which I am displaying below in csv
format:
Table # 1:
Store, Sales
A, 5000
B, 4000
C, 6000
D, 2000
Table # 2:
Store, Region
1,North
2,South
3,North
I need to fill a table with the following format:
Region, Total Sales
North, <Total sales for North>
South, <Total sales for South>
I need hep with the <Total sales formulas>. I know a workaround is to create
an additional column next to Table 1 to display the Region and then use
SUMIF. However, this is not something that I can do in this situation. I
tried the following formula, with A8="North":
=SUM(IF(VLOOKUP(Table1_Col1,Table2,2,0)=A8,Table1_Col2,0))
However, this formula gives me 17,000 as result (instead of 11,000). If I
replicate the formula row by row (in non-array format), it does work...
Any help is greatly appreciated! But please remember that I need only one
formula in one cell.
Thanks!
Lucas