weighted averages from different columns

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
More
2 years 7 months ago - 2 years 7 months ago #10496 by bert
Replied by bert on topic weighted averages from different columns
A sort of table of truth of that formula would look like this.


Attachments:
Last edit: 2 years 7 months ago by bert.
More
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.
Attachments:
Last edit: 2 years 7 months ago by bert.
More
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.