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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks