LinkBack URL
About LinkBacks
Hi,
Does this help you. Assumes Range is B2 to B100 and counts if between 51 to 100
=SUMPRODUCT(--(B2:B100>=51),--(B2:B100<=100))
VBA Noob
Hi,
Does this help you. Assumes Range is B2 to B100 and counts if between 51 to 100
=SUMPRODUCT(--(B2:B100>=51),--(B2:B100<=100))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks