The following code is part of an array formula I have
written: (F1:F25<100). However, I would like a code that
would find data not just <100 but also 25??

=countif(F1:F2525)-countif(F1:F25=100)

=sumproduct((F1:F2525)*(F1:F25<100))


--
Regards,
Tom Ogilvy

"crabt23" wrote in message
...
The following code is part of an array formula I have
written: (F1:F25<100). However, I would like a code that
would find data not just <100 but also 25??