marklemachin
New Member
- Joined
- Mar 23, 2018
- Messages
- 9
qty | gp | salesperson | sku |
1 | 4% | andrew | #N/A |
1 | 4% | andrew | 2 |
2 | 3% | andrew | 2 |
3 | 2% | kyle | 2 |
4 | 4% | kyle | #N/A |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I want the weighted average of column 2 in regards to column 1 when column 3 equals andrew and when column 4 does not equal #N/A.
My formula is this: =SUMPRODUCT(--(C2:C6="andrew"),--(D2:D6<>"#N/A"),B2:B6,A2:A6)/SUMPRODUCT(--(C2:C6="andrew"),--(D2:D6<>"#N/A"),A2:A6)
No matter how I twist the formula I get an #N/A error