andrewwhitfield
New Member
- Joined
- Mar 28, 2011
- Messages
- 31
I'm hoping someone can help me with an alternative to the Sum Product formula i have been using.
SUMPRODUCT(--(C:C=C3),N:N)<>0
Lets say for example the same value exist in C3, C4, C5 i get the return from the formula where the SUM of N3, N4 N5 does not equal 0. What I actually need is to identify where the value in any of N3, N4 N5 does not contain zero.
My issue being positives and negatives could net to zero currently which I need to avoid.
SUMPRODUCT(--(C:C=C3),N:N)<>0
Lets say for example the same value exist in C3, C4, C5 i get the return from the formula where the SUM of N3, N4 N5 does not equal 0. What I actually need is to identify where the value in any of N3, N4 N5 does not contain zero.
My issue being positives and negatives could net to zero currently which I need to avoid.