Hi,
I have a question about writing a formula (preferably not an array one) to calculate a weighted average. I need it to satisfy several conditions. First off, there are 3 possible conditions in column M (A,B, and C). If column M = A or B then column N is a number. If not, then column N is empty. Also, column V is either Z or X. What I need the formula to do is calculate the weighted average rate based on a certain parameter W for the columns R, T, and Y. Then if column M = A or B (column N is a number) if column M= A or B then pull up the weighted average for column N (where N is a number). If column M is C, I need the formula to look up info in column S based on Q and E if column V is Z or look up in column D if V is X.
Any ideas would be much appreciated. This is what I have so far, but it isn't really working too well:
{=IF(OR(M="A",M="B"),SUMPRODUCT(((W=),R*T*Y)/SUMPRODUCT((W=),R*T)),IF(V="Z",((Q=)*(E=),S),IF(V="X",((Q=)*(E=),D),"")))}
Thanks in advance,
shaero
I have a question about writing a formula (preferably not an array one) to calculate a weighted average. I need it to satisfy several conditions. First off, there are 3 possible conditions in column M (A,B, and C). If column M = A or B then column N is a number. If not, then column N is empty. Also, column V is either Z or X. What I need the formula to do is calculate the weighted average rate based on a certain parameter W for the columns R, T, and Y. Then if column M = A or B (column N is a number) if column M= A or B then pull up the weighted average for column N (where N is a number). If column M is C, I need the formula to look up info in column S based on Q and E if column V is Z or look up in column D if V is X.
Any ideas would be much appreciated. This is what I have so far, but it isn't really working too well:
{=IF(OR(M="A",M="B"),SUMPRODUCT(((W=),R*T*Y)/SUMPRODUCT((W=),R*T)),IF(V="Z",((Q=)*(E=),S),IF(V="X",((Q=)*(E=),D),"")))}
Thanks in advance,
shaero
Last edited:
