💻 Software
How do you include an OR inside a SUMPRODUCT function, in Microsoft Excel?
Fresh7 days ago
Mar 15, 202662355 viewsConfidence Score0%
0%
Problem
How do you include an inside the function in Excel? I currently use two formulas because I have two variables I want it to count: 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.
Error Output
=Sumproduct((A3:A159=B3:B159)*(D3:D159="Target A")) =Sumproduct((A3:A159=B3:B159)*(D3:D159="Target B"))
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do you include an OR inside a SUMPRODUCT function, in Microsoft Excel?
Low Risk
The "plus sign" ( ) is for in array formulas (and ). =Sumproduct((A3:A159=B3:B159)*((D3:D159="Target A")+(D3:D159="Target B"))) With , every comparison is evaluated to and . In Excel, can be represented by any non-zero number, while is equivalent to…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix