Thread: sumproduct
View Single Post
  #1   Report Post  
FLKULCHAR
 
Posts: n/a
Default sumproduct

Why is:


=SUMPRODUCT(--(F1:F5={2,3,4,5}))

equivalent to the number of times 2,3,4, or 5 occur within the range??

thanks,

flkulchar