How do you include an OR inside a sumproduct? I currently use two sumproduct formulas because I have two variables I want it to count:
=Sumproduct((A3:A159=B3:B159)*(D3:D159="Target A")) =Sumproduct((A3:A159=B3:B159)*(D3:D159="Target B"))
Is there a simple way to write that in one formula? I know it's not killing me to write it in two, but if it can be done better then I'm all ears (always willing to learn).