- Thank you received: 0
weighted averages from different columns
- Janinem
- Topic Author
- Offline
Less
More
2 years 7 months ago #10495
by Janinem
Replied by Janinem on topic weighted averages from different columns
no it is not - it is basically either column 1 or 2 but not both
- bert
- Offline
Less
More
- Thank you received: 749
2 years 7 months ago - 2 years 7 months ago #10496
by bert
Replied by bert on topic weighted averages from different columns
Last edit: 2 years 7 months ago by bert.
- bert
- Offline
Less
More
- Thank you received: 749
2 years 7 months ago - 2 years 7 months ago #10497
by bert
Replied by bert on topic weighted averages from different columns
There are three sections in it, separated by a + sign.
The first one counts the number of 1s in C1,C2,C3. If the number of 1s equals 1, then yields a 1
The second section, takes into account C2 and C3' condition
The third section, takes into account C1 and C3' condition
There is probably a more elegant solution to this formula but I did not have my morning coffee yet and this one is hopefully easier to follow.
Let me know if it works for you. Just be careful with the parentheses.
The first one counts the number of 1s in C1,C2,C3. If the number of 1s equals 1, then yields a 1
The second section, takes into account C2 and C3' condition
The third section, takes into account C1 and C3' condition
There is probably a more elegant solution to this formula but I did not have my morning coffee yet and this one is hopefully easier to follow.
Let me know if it works for you. Just be careful with the parentheses.
Last edit: 2 years 7 months ago by bert.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
2 years 7 months ago #10498
by Janinem
Replied by Janinem on topic weighted averages from different columns
Yay that has seemed to do the trick. Thank you thank you thank you.