Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I'm struggling to pull below conditions together. I'd like to have a formula that will count values between 1 and 5 only when cell U13 contains the text 1-5.
do it like this:
=ARRAYFORMULA(SUM(IF((K2:K22>=1) * (K23:K22<=5) * (U13="1-5"), 1, )))
Required, but never shown