excel formula
Although the array-entered formula suggested by someone else works, I
try to avoid them whenever possible. In many cases, they can be
replaced with a similar SUMPRODUCT() formula. For example:
=SUMPRODUCT(
--(A1:A5="FAC"),
--(B1:B5=1),
--(C1:C5="SL")--(C1:C5="VL"))
|