br_allison
New Member
- Joined
- May 18, 2015
- Messages
- 5
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[TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl79, width: 106"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance!
/br_allison
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[TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl79, width: 106"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance!
/br_allison
Last edited by a moderator:
