Thread: excel formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default 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"))