excelactuary
New Member
- Joined
- Feb 18, 2013
- Messages
- 45
Hi,
I have the following table:
<tbody>
</tbody>
In the column A and B we have only two possbile values:
A: 1 and 2
B: 3 and 4
Now, in this example D4, D5 and D14 have the number 15. But, only D4 and D5 have the same corresponding entries in A, B and D (A4=A5=1, B4=B5=3, D4=D5=2009). So, for these values I would want to calculate in a new cell the following: (E4+E5)/(F4+F5).
More generally, I would like a formula which parses the column C for identical entries (for instance: looking in the whole column for 15) and then extracting all those entries which have the same corresponding values in the column A, B, and C, and in the end calculating sum(E_i)/sum(F_i) for all i entries which were extracted in the previous step.
Do you have an idea, how to implement this?
Thank you very much!
I have the following table:
A | B | C | D | E | F |
1 | 3 | 72 | 2009 | 27,07 | 350 |
1 | 3 | 17 | 2013 | 0 | 250 |
1 | 3 | 15 | 2009 | 0 | 600 |
1 | 3 | 15 | 2009 | 0 | 500 |
1 | 3 | 79 | 2012 | 1.177,42 | 500 |
1 | 3 | 20 | 2010 | 18.012,33 | 460 |
1 | 3 | 74 | 2009 | 45,82 | 1.000,00 |
1 | 3 | 89 | 2014 | 17.926,00 | 1.000,00 |
1 | 3 | 54 | 2008 | 0 | 400 |
1 | 3 | 61 | 2011 | 405,38 | 500 |
2 | 3 | 89 | 2010 | 819,78 | 800 |
2 | 3 | 99 | 2009 | 0 | 250 |
2 | 4 | 15 | 2008 | 0 | 500 |
2 | 4 | 18 | 2011 | 0 | 290 |
2 | 4 | 20 | 2016 | 0 | 288 |
2 | 4 | 88 | 2011 | 0 | 422 |
2 | 4 | 12 | 2008 | 0 | 533 |
2 | 4 | 12 | 2016 | 1.741,94 | 400 |
2 | 4 | 67 | 2014 | 421,94 | 400 |
2 | 4 | 69 | 2013 | 438,71 | 400 |
2 | 4 | 48 | 2010 | 1.063,14 | 300 |
<tbody>
</tbody>
In the column A and B we have only two possbile values:
A: 1 and 2
B: 3 and 4
Now, in this example D4, D5 and D14 have the number 15. But, only D4 and D5 have the same corresponding entries in A, B and D (A4=A5=1, B4=B5=3, D4=D5=2009). So, for these values I would want to calculate in a new cell the following: (E4+E5)/(F4+F5).
More generally, I would like a formula which parses the column C for identical entries (for instance: looking in the whole column for 15) and then extracting all those entries which have the same corresponding values in the column A, B, and C, and in the end calculating sum(E_i)/sum(F_i) for all i entries which were extracted in the previous step.
Do you have an idea, how to implement this?
Thank you very much!
Last edited: