Thread
:
sumproduct
View Single Post
#
1
FLKULCHAR
Posts: n/a
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
Reply With Quote