How do you include an
OR inside the
sumproduct function in Excel? 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? 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.