Sum up values in a cross-table

[br_allison]

Hi!
I have a cross-table as a source sheet and am trying to develop an additional sheet where the data would be summed up depending on some conditions.

Here is what I have in a source sheet:

-- removed inline image ---


A=account (variable)
B=Function (variable)
C=Free (variable)
D=Product (variable)
E:J - values.

What I want to achieve is a formula (function) which would sum up all values for this particular account, function, free1 and product for year 2015, month Jan ACC and scenario Actual. In another column scenario will be different (e.g. budget). In another column year will be different (e.g. 2014).

Is there any way to make it work with one function? I tried SUMIFS, but it doesn't seem to like looking for values in rows:



So, I don't get any result - only

#VALUE!

<tbody>
</tbody>

Thanks in advance!

/br_allison

 

[br_allison]

Oh, the printscreens looks... odd.

Here is the source data.

0	0	0	0	LOC	0	0	0	IC
0	0	0	0	2015	2015	2015	2015	2015
0	0	0	0	Actual	Actual	Actual	Actual	Actual
0	0	0	0	Jan ACC	Jan	Feb ACC	Feb	Mar ACC
3033-000-01	Function	Free1	P-99-99	0	0	0	0	0
3033-000-01	Function	Free1	Product	9604	9604	21972	12368	28763,52
3033-000-02	Function	Free1	3408_Finance_Print	-2572	-2572	-5039	-2467	-7421,37

<colgroup><col><col><col><col><col span="4"><col></colgroup><tbody>
</tbody>