=SUMPRODUCT(--(A1=sheet!$B$2:$B$5697),--(sheet!$E$2:$E$5697))
Can someone explain to me the significance of -- in the above formula. I remember seeing the -- used in other formulae as well but never understood.
Thanks.
Can someone explain to me the significance of -- in the above formula. I remember seeing the -- used in other formulae as well but never understood.
Thanks.