joelle
02-09-2006, 05:10 PM
Hello Everyone,
It's been a while and hope you all 've been great.
I have the SUMPRODUCT formula below that works but I try to understand it ( I got it from a good-hearted exceller).
Here, the formula counts the number of "Key" occurrence only when it has an "X" from the adjacent cell. So there are only 5.
However, I dont understand the SUMPRODUCT formula in the pink cell, which is:
=SUMPRODUCT(--(C2:C16="key"),--(D2 : D16="X"))
why there are 2 dashes in front of the cell range for col C and there 2 dashes in front of the cell range for col D???
Many thanks,
Nee
It's been a while and hope you all 've been great.
I have the SUMPRODUCT formula below that works but I try to understand it ( I got it from a good-hearted exceller).
Here, the formula counts the number of "Key" occurrence only when it has an "X" from the adjacent cell. So there are only 5.
However, I dont understand the SUMPRODUCT formula in the pink cell, which is:
=SUMPRODUCT(--(C2:C16="key"),--(D2 : D16="X"))
why there are 2 dashes in front of the cell range for col C and there 2 dashes in front of the cell range for col D???
Many thanks,
Nee