sufianmalik
Board Regular
- Joined
- May 7, 2002
- Messages
- 128
Anyone know how to count only if two items are satisfied?
sufianmalik said:Anyone know how to count only if two items are satisfied?
sufianmalik said:The example was:
Column A contains A, B, C , D
Column B, contains just Y and N
I want to count all the A's that are also Y's
How would i fit that in?
ivory said:i'm curious to what the "--" is for in that formula =SUMPRODUCT(--($A$2:$A$100="A"),--($B$2:$B$100="Y"))