hi guys,
I'm having a little brain freeze here
I would like sum values in cross table xy based on sum of x and y.
<tbody>
</tbody>
For example:
sum values if Column + Row >7.5. We know that there is only one such scenario 4+4 so it equals 0.21
sum values if Column + Row < 4.00. That would be 1-1,2-1,1-2 so 0.10+0.05+0.12 = 0.27
What formula could calculate this automatically based on my X value?
I tried something like =SUMIF(A1:E5,A2:A5+B1:E1>B7,B2:E5) but that doesn't work.
Thanks in advance
I'm having a little brain freeze here
I would like sum values in cross table xy based on sum of x and y.
1 | 2 | 3 | 4 | |
1 | 0.10 | 0.12 | 0.25 | 0.30 |
2 | 0.05 | 0.10 | 0.32 | 0.40 |
3 | 0.14 | 0.13 | 0.10 | 0.15 |
4 | 0.18 | 0.11 | 0.16 | 0.21 |
<tbody>
</tbody>
For example:
sum values if Column + Row >7.5. We know that there is only one such scenario 4+4 so it equals 0.21
sum values if Column + Row < 4.00. That would be 1-1,2-1,1-2 so 0.10+0.05+0.12 = 0.27
What formula could calculate this automatically based on my X value?
I tried something like =SUMIF(A1:E5,A2:A5+B1:E1>B7,B2:E5) but that doesn't work.
Thanks in advance
Last edited: