S
StephenT
Hi
Can you help?
I would like to sum a matrix according to a condition in a row and in
different condition in a column. I know how to do this one dimensionally
(either in the row or the column) using sumproduct, but what about two
dimensions?
Let me give an example, number of widgets produced each week by each type of
machine
A B C D
1 weeks>>1 2 3
2 Type 1 10 15 11
3 Type 2 20 5 10
4 Type 1 5 12 21
Etc
So, I’d like the formula to be able to Sum the number of widgets produced by
machine type 1 after week1 (ie. Weeks >1)
The formula should give the answer 15+11+12+21 = 59
Thank you
p.s. No macros please
Can you help?
I would like to sum a matrix according to a condition in a row and in
different condition in a column. I know how to do this one dimensionally
(either in the row or the column) using sumproduct, but what about two
dimensions?
Let me give an example, number of widgets produced each week by each type of
machine
A B C D
1 weeks>>1 2 3
2 Type 1 10 15 11
3 Type 2 20 5 10
4 Type 1 5 12 21
Etc
So, I’d like the formula to be able to Sum the number of widgets produced by
machine type 1 after week1 (ie. Weeks >1)
The formula should give the answer 15+11+12+21 = 59
Thank you
p.s. No macros please